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:C98...
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")