You are reading a single comment by @Drakien and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Drakien
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?