Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is it possible to run a SUMIF formula across multiple columns?
Thanks Hugh
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
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.
Thanks Shaine
