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

Colleen Jones

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

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!

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!