| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add a cell based on another cells contents?
In Total 1 line =if(B3=6651,whatever-is-January,0)
In Total 2 line =if(B3=6671,whatever-is-January,0) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Debbie" wrote in message ... 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! |
| Reply |
| 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 | |||
Linear Mode
