Hi
I've got some great info from this forum however I cannot find the answer to my current question, Although I'm sure it's been asked before.
I have a column 'M', containing either, Yes, No or 'blank'
I am using the following COUNTIFS formula to get the info I need but now I need to add the blank cells into the result when searching for a 'Yes.
=COUNTIFS('Job Log'!H:H,">="&A2,'Job Log'!H:H,"<"&A3,'Job Log'!M:M,"Yes",'Job Log'!F:F,"AW7212 Lincoln")
Can somebody help me please?
Thanks
I've got some great info from this forum however I cannot find the answer to my current question, Although I'm sure it's been asked before.
I have a column 'M', containing either, Yes, No or 'blank'
I am using the following COUNTIFS formula to get the info I need but now I need to add the blank cells into the result when searching for a 'Yes.
=COUNTIFS('Job Log'!H:H,">="&A2,'Job Log'!H:H,"<"&A3,'Job Log'!M:M,"Yes",'Job Log'!F:F,"AW7212 Lincoln")
Can somebody help me please?
Thanks