COUNTIFS "VALUE" ERROR

Occasional Visitor

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?

1 Reply

@AliciaGraham 

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")