Count if/sum if formulae

[SeekingExcelSupport]

Hi all!

Looking for some help!

I want to add the total value for each reference

So final hours = Total hours completed by reference

Reference	Hours complete	Final hours
123	10	HELP HERE
345	12
123	8
123	20

 

[Joe4]

Welcome to the Board!

Are you looking for a running total, like this?

If so, place this formula in cell C2 and copy down:

=SUMIF(A$2:A2,A2,B$2:B2)

If that is not what you are after, please show us your expected results.

 

[Joe4]

If you are looking for the Grand Total on every row like this:

Then your formula in C2 would look like:

=SUMIF(A$2:A$5,A2,B$2:B$5)

 

[SeekingExcelSupport]

This is fantastic! Thank you so much

Welcome to the Board!

Are you looking for a running total, like this?
View attachment 97200

If so, place this formula in cell C2 and copy down:

=SUMIF(A$2:A2,A2,B$2:B2)

If that is not what you are after, please show us your expected results.

 

[Joe4]

You are welcome.
Glad I was able to help!