View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tearl42 tearl42 is offline
external usenet poster
 
Posts: 1
Default Summing cell values based on the value of another

Greetings to all,

I need to sum cell values based on the value of another. Here is the
example...
A B
1 44.00 $5,874.40
2 44.00 $-
3 44.00 $-
4 23.00 $516.67
5 44.00 $557.20

If A1:5 = 44 then sum B & the row in column A that equaled 44...

So the total should be $6431.60

I've been banging my head on this for a while and just can't seem to figure
out where I'm going...

TIA,

Tom