in a spreadsheet i want to give the word on the value of 1

December 9, 2011 at 20:54:11
Specs: Windows 7
i have used the COUNTIF function and the replace function but seem to not get this to total in the bottom of the column

See More: in a spreadsheet i want to give the word on the value of 1

Report •


#1
December 10, 2011 at 06:12:06
re: "I want to give the word on the value of 1"

What does that mean?

I do not understand what you are trying to do.

Please click on the blue line at the end of this post and read the instructions found via that link. Then post an example of your data and the expected results.

Keep in mind that we can not see your spreadsheet from where we're sitting, so you have to be specific about what you are trying to do.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
December 10, 2011 at 14:33:46
please excuse my minimal excel knowledge here...i have generated drop down boxes in a spreadsheet. each time i either select "on" or "off" a value is added/subtracted in a totals cell at the bottom of each column. if i change on to off, the cell value is reduced
please advise. thanks

Report •

#3
December 10, 2011 at 17:05:55
re: "please excuse my minimal excel knowledge here"

This has nothing to do with your level of Excel knowledge...it has to do with the proper way to post a question in a help forum.

I'll repeat what I said in my previous response:

Keep in mind that we can not see your spreadsheet from where we're sitting, so you have to be specific about what you are trying to do.

You've given us a little more information, but you still haven't given us enough detail to be able to help you.

re: "each time i either select "on" or "off" a value is added/subtracted in a totals cell at the bottom of each column"

"a value"? What value?

re: "if i change on to off, the cell value is reduced"

So, is that what you want it to do or not to do?

You still haven't explained what you are trying to do. You haven't posted the formulas you are using or provided any information as to how the selection of the Drop Down choices impacts the "total cells".

Until you supply enough detail,we can't help you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question