Count IF

[mtagliaferri]

Hi All,
I have the following formula that counts values between I14 and I114 if a date range is between dates reference in B8 and C8

=COUNTIFS(I14:I114,">="&C8,I14:I114,"<="&B8)

I need to filter more within this range for example it only has to count if values are >0 (From 1 upwards) in a cell range of P14 and P114.

How can I add this to the formula?

Thanks

 

[sandy666]

Syntax:
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

 

[DanteAmor]

Try this:

=COUNTIFS(I14:I114,">="&C8,I14:I114,"<="&B8,P14:P114,">"&0)

 

[mtagliaferri]

Thank you sandy666 & DanteAmor!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[sandy666]

You are welcome