Range with multiple columns with COUNTIFS


One range in my COUNTIFS formula has several columns included. If I use this range on COUNTIF (no S on it), it works perfectly but, when I include in COUNTIFS, it does not work. (#Incorrect Argument Set). I then split all these columns in one range, criterion and now does not count anything. Do you have any information on how I can make COUNTIFS read this group of columns as COUNTIF does?

Range 2 include 9 columns side by side.

Range 1 is just one column

=COUNTIFS (Range 2, "1", Range 1, "4") It does not work - #Incorrect Argument Set

=COUNTIF (Range 2, "1") It works perfectly.

=COUNTIFS (Col1:Col1, "1", Col2:Col2,"1",......Col9:Col9,"1", Range 1, "4") =0, does not count anything.

Thank you.


Best Answer


  • Al ISS
    Al ISS ✭✭

    Paul, I was able to do it following the first option. It is became a big formula, but it works. Thank you.😀

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy yo help! 👍️

    Please don't forget to mark my answer as "helpful". This lets others searching for a similar solution know that one may be found here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!