Sumif

CamCrichton

sum all values in OverUnder column if a specific artist is assigned in the Artist column

=SUMIF(Artist:Artist, Artist2, OverUnder20:OverUnder500)

returns error #incorrect argument set

If I remove the range numbers from OverUnder it works (until I add another expression in the same column then it produces a circular reference). With the range numbers all ranges highlight as expected, the format matches the example, this is about as simple as it gets, can anyone please explain why it isn't working?

Andrée Starå

Hi,

In a SUMIF the sum range has to be the same as the range for it to work. I've added two options below. Beware that the rows referenced need to be in the sheet so if you don't have 500 rows it will give an #Unparsable error.

SUMIF(Artist:Artist, Artist2, OverUnder:OverUnder)

SUMIF(Artist20:Artist500, Artist2, OverUnder20:OverUnder500)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

CamCrichton

Thanks Andrée,

from the help tip...

"sum_range (optional) - the group of cells to add, if different from the range"

I guess they just put these tips in to confuse us.

 

regards,

Cam

Andrée Starå

Happy to help!

It can be a little confusing, and I now see that I didn't help. With range, I mean that the length of the sum_range has to be the same. 

Range in the tip is if you want to sum another column for example, but it still has to be the same length. 

Have a fantastic weekend!

Best,

Andrée