Forum Discussion
Cumulative Totals and SumProduct Formulas
Needing a few more tweaks to my formulas. We are changing a cumulative log into a monthly log. I am needing to calculate the total items in C19:c233 and divide it by counts in J19:233, for the month ...
Thank you for the information. I have added another column to help with the counts and they are working. I was told to add YTD totals columns but unsure of the formula to calculate them. The monthly % is working. But the YTD % is not. Any Suggestions?
Hi Karen,
In cell D3, add the formula =SUM($C$3:C3) and copy it in the rest of the column.
In cell F3, use the formula =SUM($E$3:E3) and copy it in the rest of the column.
And in column H (YTD % Total), use the formula =F3/D3.
I suppose this is the simplest way to do it.
Kr
TK
In cell D3, add the formula =SUM($C$3:C3) and copy it in the rest of the column.
In cell F3, use the formula =SUM($E$3:E3) and copy it in the rest of the column.
And in column H (YTD % Total), use the formula =F3/D3.
I suppose this is the simplest way to do it.
Kr
TK
Thank you for the information. I am using the following formula in a different worksheet =IF(C3=0,"",SUM(C$3:C3)) for YTD totals But I still need to have it show zeros if that is what the total is for that cell. Is that possible?
- Just replace the "" by zero ;)
=IF(C3=0,0,SUM(C$3:C3))