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!
|