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.
Can anyone advise how I insert 'don't count blank cells' into this formula?
Thanks in advance