Hi all,
I'm struggling to SUM certain numbers based on several criteria, without using a helper column. It makes the file unnecessarily big and messy, but I cannot figure out how to work around it.
Would such a calculation work with a FREQUENCY array formula? Could anyone have a look at my sample attached?
The RED cells are the helper cells that I want to get rid of, where I currently do some pre-calculations to get to the final results (YELLOW).
Bookmarks