MS Excel / VBA help thread

You are reading a single comment by @rhb and its replies. Click here to read the full conversation.

•

rhb

Brain melt over a simple formula. Thinking sumif/xlookup combo but might be overlooking something simple.

180 rows of financial lines

Column A has category check values b, c or m

Column C has sub category check values b or e

Column E-P has £ value per month Jan-Dec respectively.

I want a mini table of 3 sum totals for the categories be, ce of me.

Not a pivot table ideally.

Brain has got stuck. Any ideas?

•

Drakien in reply to @rhb

Helper columns for be, ce, me, and then a pivot table.
•

aggi in reply to @rhb
Ideally, I'd unpivot the data and then put it in a pivot.

But FILTER should do it (obviously fine tune as desired):
```
=SUM(FILTER($C$3:$N$31,($A$3:$A$31=P2)*($B$3:$B$31=Q2)))
```
I don't think SUMIFS works over that kind of range.

About

Avatar for rhb @rhb started