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

Find more posts tagged with

Accepted answers

Andrée Starå

Hi Andre,

Try something like this.

=SUMIF(ColA:ColA; "Word"; ColB:ColB)

The same version but with the below changes for your and others convenience.

=SUMIF(ColA:ColA, "Word", ColB:ColB)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andre Drinkwater

Thank you so much Andrée.

Working perfectly.

All comments

Andrée Starå

Hi Andre,

Try something like this.

=SUMIF(ColA:ColA; "Word"; ColB:ColB)

The same version but with the below changes for your and others convenience.

=SUMIF(ColA:ColA, "Word", ColB:ColB)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andre Drinkwater

Thank you so much Andrée.

Working perfectly.

Andrée Starå

Excellent!

Happy to help!

Sommer

I have items that are divided into regions in Column A and I want to sum the population values of Column B IF then share the same region in Column A. I am trying this formula and it is presenting a value - but the value is incorrect. Help? =SUMIF(Region:Region, =Region@row, Population:Population)

Genevieve P.

Hi @Sommer

Is your Region column multi-select? Can you also confirm that the Population column is housing the values as numerical, not text? Numbers will appear on the right of the cell and text appears on the left.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.