SUMIF across multiple columns

Hugh McKinney

Is it possible to run a SUMIF formula across multiple columns?

Thanks Hugh

Shaine Greenwood

Hi Hugh,

 

The columns should have numbers in them if you're going to sum them, but you can sum across a range of columns by including the first and last column in your range:

 

=SUMIF(Price:Quantity, 1)

 

If your columns aren't contiguous, you can sum them by separating them with a SUMIFS:

 

=SUMIFS(Price:Price, Quantity:Quantity, >25, [Order Volumn]:[Order Volumn], Quantity:Quantity, >25)

 

More on building formulas is in our help center: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

Shaine Greenwood

Actually, you might have to add SUMIF formulas together, as a SUMIFS will only count when all criteria are met:

 

=SUMIF(Price:Price, 1) + SUMIF(Quantity:Quantity, 1)

 

EDIT: You might need to do this if your columns aren't contiguous.

Hugh McKinney

Thanks Shaine