Hi, I have the following data:
A B C D
Phone # Worked PI NI
55555555 Y 0.00 2.00
66666666 10.00 12.00
77733222 Y 3.50 8.00
45466666 Y 0.00 0.00
table is 4 columns (phone # / Worked / PI / NI) wide by numerous rows deep...
Basically, I want to do a COUNTIF function that will basically count the number of entries that have a PI greater than 0 AND a Y in the worked column.. if that makes any sense I don't want it counting ones where the PI and NI columns are zero...
I can't seem to figure it out: I thought that something like this might work:
COUNT(IF(B2:B5, "Y") AND (C2:C5, ">.01"))
Any help would be greatly appreciated!!!
Drew
A B C D
Phone # Worked PI NI
55555555 Y 0.00 2.00
66666666 10.00 12.00
77733222 Y 3.50 8.00
45466666 Y 0.00 0.00
table is 4 columns (phone # / Worked / PI / NI) wide by numerous rows deep...
Basically, I want to do a COUNTIF function that will basically count the number of entries that have a PI greater than 0 AND a Y in the worked column.. if that makes any sense I don't want it counting ones where the PI and NI columns are zero...
I can't seem to figure it out: I thought that something like this might work:
COUNT(IF(B2:B5, "Y") AND (C2:C5, ">.01"))
Any help would be greatly appreciated!!!
Drew