running32

asked on

# count row in excel if = to 2 conditions

I need to count row P in my excel spreedsheet if row H > 17 and row P = 1 or 3.

How can I write the query to do this in and excel field.

thanks

How can I write the query to do this in and excel field.

thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Assuming the range is 1,2,3 then try

=COUNTIFS(H1:H9999,"= 17",P1:P9999,"<4")-COUNTIFS(H1:A9999,"= 17",P1:P9999,"=2")

=COUNTIFS(H1:H9999,"= 17",P1:P9999,"<4")-COUNTIF

ASKER