Excel Countifs and Sumproduct

user_2201603 0
Viewed 81

Using an excel function, I'd like to get a total count for "WO", "Satisfactory Performance" and anything in October from the following data set. My expected total should be 1. 

Region  Performance Rating       Date
WO      Satisfactory Performance    10/1/2018
01      Satisfactory Performance    10/18/2018
WO      Satisfactory Performance    11/16/2018

I've tried the following formula returning a value of 0, but it should be 1:

=COUNTIFS(Q103:Q105,"WO",R103:R105,"Satisfactory Performance",S103:S105,+SUMPRODUCT(1*(S103:S105)=10))

Any suggestions is greatly appreciated.

Thanks!

excel-formula
1 Answers

I really don't know what +SUMPRODUCT(1*(S103:S105)=10) is intended to accomplish. Typically you would simply bracket the month with COUNTIFS.

=COUNTIFS(Q103:Q105, "WO",
          R103:R105, "Satisfactory Performance",
          S103:S105, ">="&date(2018, 10, 1),
          S103:S105, "<"&date(2018, 11, 1),)
Admin1
Related