Sumifs

[floricita]

Hi there,

I was wondering if you could help me please.

In col B I have expenditure. In col C I have a tick, x and a question mark beside each.

What I need to do somewhere else on the spreadsheet (doesn't particularly matter where).

Is sum all ticks in the data range. Then below sum all the x, then all the ?

I know I could sort and then do a normal sum, however, the x ? etc will changeand I want the fomrula in the summary sheet for the total to change at the same time.

Thanks

[zbor]

Can you upload example workbook?

[floricita]

Sure.

This is a snapshot of what is required.

However, there are col between a and b in the real worksheet which are sensitive, so I deleted them from the sample. But I'm assuming that the method would be the same, just widen the data range

[Colin Legg]

You could quickly summarise it with a pivot table.


If you really want to go the formula route, the formulae in your workbook would be

B23
=SUMIF($B$3:$B$20,A23,$A$3:$A$20)

B24
=SUMIF($B$3:$B$20,"~"&A24,$A$3:$A$20)

B25
=SUMIF($B$3:$B$20,A25,$A$3:$A$20)

[floricita]

Thanks mate.

I did do it in pivot. However, the end users are no able to use excel that well and they need the sums to update by themselves without doing anything