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!