How do assign values to my spread sheet?

May 4, 2011 at 16:41:46
Specs: Windows 7
I need to label the numbers "1" and "3" to have the values of "3" and "1" respectively, and then have those numbers added together. How do I do this? And preferably, how do I label a block of cells to make these calculations quickly? Thank you.

See More: How do assign values to my spread sheet?

Report •

May 4, 2011 at 19:49:17
Is that what you need?


This will return a 3 if A1 contains 1, a 1 if A1 contains 3 and a blank cell if A1 contains anything other than 1 or 3.

Drag this down (or across) to apply to your "block of cells". (I'm not quite sure what you mean by a "block of cells" so I can't be any more specific than that.)

All you need to do after that is to SUM all of the cells that contain the formulas.

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

Report •

May 4, 2011 at 19:50:20
Cool thanks, that really helps

Report •

Related Solutions

Ask Question