SUM Column B if Column A contains a certain value

Hi all,

So I am trying to add all values of a column, but only where the row has a certain value on column A into a sheet summary field.

This is what I have but it does not work.

=IF(ColA:ColA = "Word"; SUM(ColB:ColB))

I think I understand why, but do not know how to write the function correctly.

Note that if I do this on a single line, my function works perfectly.

Thanks for helping

Best Answers

  • Andre Drinkwater
    Andre Drinkwater ✭✭✭
    Answer ✓

    Thank you so much Andrée.

    Working perfectly.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!