Issue with CountIFS Formula

MandyOnAMission
edited 12/09/19 in Smartsheet Basics

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

  • Paul Newcome
    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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com