Using two conditions in COUNTIF

[hence]

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

 

[barry houdini]

thanks so much! the last one worked!! wasn't even aware of that formula! still kinda new..

I have one more question... I have a deadline for a project for Dec 01 2006.

I want to create a formula that automatically calculates the remaining BUSINESS days till that date.. ie.. no weekends.. so 5 days a week

is this possible? can it update as each day passes automatically?

tks again!

drew

Did you try networkdays suggestion?

To calculate number of business days (inclusive) between today and a date in A2

=NETWORKDAYS(TODAY(),A2)

another way without Analysis ToolPak

=SUM(INT((WEEKDAY(TODAY()-{2,3,4,5,6})+A2-TODAY())/7))