Hi all,
Having an issue with a formula;
I want to sum column 3 based on fulfilling criteria from 2 other columns eg
If Column A says "Product" and column B says "2024 May" then sum column Column C
It may seem simple, but having issues...
Thanks
=SUMIFS([Column C]:[Column C],[Column A]:[Column A], "Product", [Column B]:[Column B], "2024 May")
In my example I have brackets around the column names since there is a space in the way that I have them labeled. If yours doesn't for example the name of Column A is Item, then you would use Item:Item.
Hi @Ian Cummings
The formula should be:
=SUMIFS([Column C]:[Column C], [Column A]:[Column A], "Product", [Column B]:[Column B], "2024 May")
To sum the rows which fulfil the criteria.
What issues are you having? I am guessing you have some kind of error message, can you advise what it is if so.
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.
