SUM Column B if Column A contains a certain value
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
Help Article Resources
Check out the Formula Handbook template!