View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Debbie Debbie is offline
external usenet poster
 
Posts: 90
Default 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!