SOLVED

Formula Help!!!

New Contributor

I am trying to create a formula in excel that counts the items in column G that an open date (blank), and also have days open greater than 30 in column H.

Column G = date

Column H = days open

I hope I am explaining this correctly...

Please help

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@All_Purpose_Mike 

Perhaps

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

Adjust the ranges as needed.

Thank you!