Issue with CountIFS Formula

MandyOnAMission

For some reason I'm getting the following Argument Error and I have no idea what I'm missing, I'm just not seeing it.

 

=COUNTIFS({Internet Product}, "up to 50/50 Internet, Managed Wifi", {Internet Products}, "up to 50/50 Internet, Managed Wifi")

Internet Product and Internet Products are two different columns on two different sheets.

Can anyone see the issue?

 

Paul Newcome

You would need to do a separate COUNTIFS for each sheet and add them together.

 

=COUNTIFS({Internet Product}, "up to 50/50 Internet, Managed Wifi") + COUNTIFS({Internet Products}, "up to 50/50 Internet, Managed Wifi")

 

Cross sheet references within the same function must be from the same sheet and must be of the same size.