How can I calculate total hours by project but not repeat the formula in every row that matches?

Hello, I found a question from 2021 that had been answered with a formula, so I gave that a try for my sheet. It works, but I'm getting the sum on every row that has a matching project ID. How can I just get the sum once for each project so that I can run a report and show these totals?

This is the formulas that I used based on the older thread:

=IFERROR(IF([Project Hours]@row = 0, "", SUMIFS([Project Hours]:[Project Hours], [Project ID]:[Project ID], [Project ID]@row)), "")

There's over 4,000 entries in this sheet, so I don't want to have to manually note each project's total hours. I'm sure there is a solution, I just don't know what it is!

Thanks for your help! Colleen

Find more posts tagged with

Accepted answers

SoS | Dan Palenchar

Hello @Colleen Jones,

If your goal is to show this in a report you don't actually need the formula in the Sheet.

Simply make a report and group it by Project ID and then add a Summary field to SUM the Project Hours columns.

Hope this helps!

All comments

SoS | Dan Palenchar

Hello @Colleen Jones,

If your goal is to show this in a report you don't actually need the formula in the Sheet.

Simply make a report and group it by Project ID and then add a Summary field to SUM the Project Hours columns.

Hope this helps!

Colleen Jones

Thanks for your help, @Dan Palenchar, I'll give that a try! That seems much easier that my method!! Colleen :)

SoS | Dan Palenchar

My pleasure, happy reporting @Colleen Jones!

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.