Multiple Countifs I cannot seem to find the error in my formula below in my mult

Question

Multiple Countifs

I cannot seem to find the error in my formula below in my multiple countifs formula.

=COUNTIFS('[National'!$E:$E,A2)+COUNTIFS('[National'!$AI:$AI,"<>"&"")+COUNTIFS('[Report'!$AO:$AO="",'[National'!$AN:$AN,"<=2/26/2015",'National'!$AN:$AN,">=3/16/2015")))

I am trying to count the dates in column AN in the National report for the dates that fall between 2/26/2015 and 3/16/2015 but to only count these if column AO equals blank and column AN does not equal blank..

I hope that makes sense..

Thanks !!

Explanation / Answer

Hello !

I left out the reference to the workbook but you know how to put that in. Try this

=COUNTIFS(Sheet1!B1:B1000,A2,Sheet1!AI1:AI1000,"<>",Sheet1!AO1:AO1000,"",Sheet1!AN1:AN1000,">=" & DATE(2015,2,26),Sheet1!AN1:AN1000,"<="&DATE(2015,3,16))

Note also in your formula I think you got the bits in my formula in bold the wrong way around so I changed it. Once again increase the 1000 rows if you need but avoid full columns.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.