ExcelBanter - Summing cell values based on the value of another

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Summing cell values based on the value of another (https://www.excelbanter.com/excel-discussion-misc-queries/254588-summing-cell-values-based-value-another.html)

tearl42

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

joemeshuggah

Summing cell values based on the value of another

=SUMIF(A:A,A1,B:B) or =SUMIF(A:A,44,B:B) if you just need 44

"tearl42" wrote:

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

All times are GMT +1. The time now is 07:32 PM.