Forum Discussion
COUNTIFS "VALUE" ERROR
I am trying to create a countifs formula with 3 arguments, excel is giving a Value error ---
ex. =COUNTIFS('AGENT ROSTER'!A3:A913,"=SiteName", 'AGENT ROSTER'!B3:B913,"=Chat",'AGENT ROSTER'!C3:C981,"=Active")
Where is the error? Can we have three arguments in a countif?
All ranges must have the same size, so change the formula to
=COUNTIFS('AGENT ROSTER'!A3:A913,"=SiteName", 'AGENT ROSTER'!B3:B913,"=Chat",'AGENT ROSTER'!C3:C913,"=Active")
