Hi there,
I'm looking for a formula that will allow me to sum the number of options available in an array with a single criteria.
On the example sheet attached, I want to know the number of "ACC" styles that I am offering in the range c$4:i$8.
By using the filter on the "function" column, I know my answer is 5, but how can this be formulated into the yellow cells?
I have tried various versions of SUM, SUMIF and SUMPRODUCT without success and keep getting a #VALUE error.
Any help with be much appreciated!
Thank you!
Bookmarks