T
tearl42
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
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