Squeezing more conditions into a sample SUMPRODUCT formula - show a novice pls!

Hi

Yes a COUNTIFS() function would be infinitely preferable and with a big database far more efficient.

See if the attached gives you some ideas. Note that I've added a helper column F to test whether at least one of columns A,B or C contains a value. The default standard for a COUNTIFS() function is the AND operator. So without a helper column you would need to add three COUNTIFS() together. i.e.

=COUNTIFS()+COUNTIFS()+COUNTIFS()

using columns A, B & C respectively in each one.


Or of course if your layout lends itself a PivotTable as suggested by Miraun whilst I was typing!