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!

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!