Hello experts
I have a formula that counts the number of entries within a table based on two conditions
Condition 1 - Column I = "No"
Condition 2 - Column G = Less than 6 months
I've got a formula as below which works except it's also counting blank cells where the data has yet to be entered.
=SUM(IF(I27:I47="No",IF(G27:G47<=TODAY()-180,1,0)))
Can anyone advise how I insert 'don't count blank cells' into this formula?
Thanks in advance
Bookmarks