Issue with CountIFS Formula
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?
Comments
-
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.