I am trying to do a backward compatible countifs for exel. I have used the sumproduct formula but not getting the right result. Can someone direct me to what I may doing wrong?
'=SUMPRODUCT(COL_SECONDS_BIN=$B$5)*(COL_CALL_TYPE=$B15)*(COL_DAY_OF_MONTH=C$14)
Attached is the file. please see tab titled: Trend Chart by Call Type
Thank you for your help.
'=SUMPRODUCT(COL_SECONDS_BIN=$B$5)*(COL_CALL_TYPE=$B15)*(COL_DAY_OF_MONTH=C$14)
Attached is the file. please see tab titled: Trend Chart by Call Type
Thank you for your help.