Add up data based on filter

Topic

New Reply

I have a spreadsheet that looks like below. I want totals by the second column but don’t want to group them (which of course makes easy totaling). I want them intermixed.
Item1 Actual 100
Item2 SOW 200
Item3 Actual 300
Item4 SOW 400

Total Actual 400
Total SOW 600

How do I make the last two rows happen?

Reply | Quote

Replies

First I named the columnar data ranges to make the formulas more concise.  For the items I chose “Items”; for Actual and SOW I chose “Category”; and finally for the amounts I used “Amounts”.

For Total Actual I used =Sumif(Items,”Actual”, Amounts) to arrive at the answer.

For Total SOW I used =Sumif(Items,”Actual”, Amounts).

Reply | Quote

For Total SOW I used =Sumif(Items,”Actual”, Amounts).

Mark,

I think you wanted to type: For Total SOW I used =Sumif(Items,”SOW”, Amounts).

I have the same problem the brain gets ahead of the fingers!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Hi All – I think Mark’s formulas were meant to be what is shown in his Pic above in D12 and D13……

=SUMIF(Category,”Actual”,Amounts)
=SUMIF(Category,”SOW”,Amounts)

The pic below shows Mark’s way (Rows 12 and 13) and an alternative (Rows 9 and 10).
There are other alternatives to achieve the same answer.

Reply | Quote