Countifs across multiple columns

Options

Hi

I want to count how many times Name=xx, has Green/Yellow/red balls across 7 columns

=COUNTIFS({C-test Creation House applications Range 5}; [Column4]13; {C-test Creation House applications Range 6}; [Column5]12)

(the range 5 is the reviewer column, and the range 6 are the 7 columns)

It works if I only choose 1 column, however, when I choose the range of 7 columns, I get the error #INCORRECT ARGUMENT SET


Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    That is because your ranges have to match in size. You can either add in a "helper" column (that can later be hidden) on the source sheet for each of the three colors that counts them up per row then use a SUMIFS on the target sheet, or you can write a series of COUNTIFS that looks at each column individually and add them together.

  • hi @Paul Newcome

    When you say "match in size" do then mean that range 5 and 6 have to identical number of columns?

    I tried to make a series of COUNTIFS, but somehow I missed something, cause I cant get it to work.

    I'll give it another go :-)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!