SOLVED

My brain does not do Excell formulas

Copper Contributor

I am looking for a formula to count items in column G with a date (some are blank/open) and have days open >30 in column H.

Please Help!

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@All_Purpose_Mike 

=COUNTIFS(G2:G100,"<>",H2:H100,">30")

Thanks again, You rock!
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@All_Purpose_Mike 

=COUNTIFS(G2:G100,"<>",H2:H100,">30")

View solution in original post