Sumifs

Hello,

I was wondering if anyone could help me with a sum ifs function. A screenshot of the sheet is included. Basically I want a formula that says if the course name match and the date match, total the costs.

So in the example if the course date is 9/16/2024 and the course name is 300, add the three rows of cost.

I can get it to sum for each individually =sumif(Date:Date, [Date]@row) and =sumif(Course Name:Course Name, [Course Name]@row). But when I try to combine it does not work. I am not sure if it should be an (AND in there or something. Thanks!

Find more posts tagged with

Accepted answers

SSFeatures

Hi @Whalstead1,

You're correct that you want to use the SUMIFS function for this problem. The syntax for SUMIFS is a little bit different than the syntax for SUMIF.

This formula should work for you:

=SUMIFS(Cost:Cost, [Course Name]:[Course Name], [Course Name]@row, Date:Date, [Date]@row)

This will search the rows, and sum the costs if the course names match and the dates match.

Let me know if you have any questions about the formula!

All comments

SSFeatures

Hi @Whalstead1,

You're correct that you want to use the SUMIFS function for this problem. The syntax for SUMIFS is a little bit different than the syntax for SUMIF.

This formula should work for you:

=SUMIFS(Cost:Cost, [Course Name]:[Course Name], [Course Name]@row, Date:Date, [Date]@row)

This will search the rows, and sum the costs if the course names match and the dates match.

Let me know if you have any questions about the formula!

Whalstead1

Thank you so much! That worked!

SSFeatures

You're welcome, glad it worked!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.