Can you reference multiple columns when using SUMIF?

Matthew Ellis · 02/03/21

I need to add values in 6 or 7 different entire columns when a certain condition is met.

When I reference only one column the formula works, but when I expand to two or more, I get an Incorrect Argument error. Is this not possible?

Leibel S · 02/03/21

Can you post your Formula?

Matthew Ellis · 02/04/21

=SUMIF({Location}, ="Corporate", {# of Green shirts})

# of Green shirts accounts for 5 or 6 columns

Answers