| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a cell based on another cells contents?
I have cell "B3" that contains account 6651 so I want it to add January into
a totals cell. Now, if cell "B3" contains account 6751 instead I want it to add it to January in a differnt totals cell. b3 Jan Feb Mar Apr May 6651 1.00 2.00 3.00 4.00 5.00 Total 1 1.00 2.00 3.00 4.00 5.00 Total 2 0 0 0 0 0 or b3 Jan Feb Mar Apr May 6671 1.00 2.00 3.00 4.00 5.00 Total1 0 0 0 0 0 Total2 1.00 2.00 3.00 4.00 5.00 I've ran so many scenarios through my head I can't figure this one out. Help!? Please!? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Significant number rounding based on key cell | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Threaded Mode
