Formula error

[Paul Walsh]

Hi

Would someone please be able to help me with a formula that I'm trying to figure out.

Please see the attached excel worksheet/Data List:

I am trying to:

1. Count the total number of non-empty cells (telephone call dates) from Column A to Column L

2. Where Column M criteria is "Attendance confirmed"

and

3. Where Column N criteria is say "AIR-TIGHTNESS25Jun"

 

[Somendra Misra]

Hi,

Can you try below formula.

=SUMPRODUCT(($M$2:$M$66="Attendance confirmed")*($N$2:$N$66="AIR-TIGHTNESS25Jun")*($A$2:$L$66<>""))

Regards,

 

[Paul Walsh]

That worked....great. Many thanks