Rolling Totals for every other column?

[DashboardNovice]

In the attached file I want to create a rolling total for all Hours and Cost columns. If I only had hours and no Cost, it would be SUM($D$14:D14) in cell D15 then drag across.

But every other column is a Cost column so that would disrupt my formula.

I am trying to do rolling totals under all Hours and all Cost columns.

 

[Jake Collins]

Dear Dashboard novice

One approach is to use this formula in d15 (and then copy across)

=SUMIF($D$3:D3,D3,$D$14:D14)

 

[NARAYANK991]

Hi ,

See the file.

Narayan

 

[DashboardNovice]

Dear Dashboard novice

One approach is to use this formula in d15 (and then copy across)

=SUMIF($D$3:D3,D3,$D$14:D14)

Very nice. I was thinking SUMIF might do it, but I couldn't figure out how. Now I know. Thank you for your reply.

 

[DashboardNovice]

Hi ,

See the file.

Narayan

Thank you sir.