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

Finding the right style field in VBA 0
Word macro that can call cells out of Excel for a find and replace 0
Looking to added up based on a character from cell range 1
Looking formula that SUM values with specific value in neighboring colum 2
sum based on value in a range 0
Summing based on a range of criteria 3
Sum of absolute values based on criteria 5
Concatenate values based on Cell Value 0

Top