M
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.
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.