SumIf

[Mike]

Hi.

Is there a way to use a conditional sumif that bases the
summation on another column? For instance, in the
example below, I need to sum the amounts from column B
based on the Qtr's in column A ...

A B
Qtr Amount
1 $100.00
1 $100.00
2 $200.00
2 $200.00
3 $300.00
3 $300.00

The results should look like this:

Qtr Totals
1 $200.00 I need the conditional sums to
2 $400.00 total based on quarters
3 $600.00

Any help will be appreciated!

Mike.

 

[Mike]

Sorry ... I answered my own question after I hit "Send"

=SUMIF(A2:A13,1,B2:B13)
=SUMIF(A2:A13,2,B2:B13)
=SUMIF(A2:A13,3,B2:B13)

 

[Biff]

Hi Mike,

Here's one way:

=SUMIF(A2:A7,1,B2:B7)

This will sum all values in col B that correspond to Qtr 1
in col A. Just substitute Qtr's (1,2,3,4) as needed.

Biff