I am looking for some help to develop a SUMPRODUCT formula.
I have a couple of conditions set, assuming the conditions are met I essentially want to count how many cells are greater than another within the same column.
So far I follow methodology to compare All rows that meet condition to 1st row, then all rows that meet condition to 2nd row, then all rows that meet condition to 3rd row and all rows that meet condition to 4th row. I achieve this with 4 separate SUMPRODUCT formula.
I want to get the sum of these four SUMPRODUCT formula but without simply adding them together. My target project involves hundreds of rows and columns so this would not be practical.
I attach an example of where I have gotten to so far, i.e. I have the end result I want but I am using 4 SUMPRODUCT formula and then summing them, ideally looking to achieve this with one single formula (if it is even possible), failing that I guess I revert to using helper column (as per attached example) and sum that.
Below are the formula I currently use
Formula:Please Login or Register to view this content.
For this project I am using Mac Excel.
Any help/ideas would be gratefully received.
Bookmarks