Summing cell values based on the value of another

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing based on a range of criteria 3
Sum of absolute values based on criteria 5
Sum value in all columns that their title is the same 1
Formula Needed : Sum on Conditions 3
Summing Based on Conditions using Array 1
Summing values within a value? 1
Summing values of same names 4
Summing a range based on value criteria 2

Top