Countifs and Or function

[tobysdhc]

Hello,

I am using the formula below to create some summary information. But I am having trouble with the first part of the formula (in green font). I need it to include "01 OR "04". Any ideas?

Thanks,

=COUNTIFS(Log!F2:F1000,OR("01","04"),Log!I2:I1000,">45131",Log!I2:I1000,"<45437",Log!G2:G1000,"Yes",Log!A2:A1000,D2))

 

[Joe4]

There are various ways of doing this.
See here: Excel COUNTIF and COUNTIFS with OR logic

 

[Jeffrey Mahoney]

Unfortunately Countifs doesn't do OR very well. Here is a solution
=sum(COUNTIFS(Log!F2:F1000,{"01","04"},Log!I2:I1000,">45131",Log!I2:I1000,"<45437",Log!G2:G1000,"Yes",Log!A2:A1000,D2)))