• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating cumulative automatically

Hi Team,

I have domain-wise data where the stats (Pass,Fail and Blocked) are mentioned day-wise
The yellow columns will have cumulative counts for that particular domain and for the previous days till date
Can I have a another formula which will be more robust and automatic than this tedius one, as the attached data is very small sample as my original data has more than 25 domains and 30 dates.

Thanks,
Jagdish
 

Attachments

  • Cumulative count calc.xlsx
    11 KB · Views: 2
how about
=SUMIFS(D$4:D4,$B$4:$B4,$B4)
copied down and across

see K,L,M - so you can compare with expected results
 

Attachments

  • Cumulative count calc-ETAF.xlsx
    11.5 KB · Views: 4
Back
Top