Thanks to your wonderful site I was able to solve half my formula problem
I have the following formula:
=SUMPRODUCT((C4:C304=701)*(L4:L304>=0.01))
But I need it to also look at M4:M304 and N4:N304 and if L,M OR N are >=0.01 count but sometime there might be a value in L M and N but i only want it to count once for that row.
Thanks in advance for any help.
I have the following formula:
=SUMPRODUCT((C4:C304=701)*(L4:L304>=0.01))
But I need it to also look at M4:M304 and N4:N304 and if L,M OR N are >=0.01 count but sometime there might be a value in L M and N but i only want it to count once for that row.
Thanks in advance for any help.