2Answers

# The excel column is evaluated downward, and the data is not automatically accumulated when it is zero.

Asked by: David 199 views IT

Addition: The “cumulative integral” formula is “upper grid” + “peer monthly score”, and the monthly score “0” is 0 for quoted empty data. How to make the monthly score have no data, the accumulated score is not calculated, or displayed for"". Thank you.

+5

VotesFigure effect:

C3 cell input formula:

=IF(A3=0,"",$C$2+SUM($A$3:$ A3))

Pull down formula

Allen- April 20, 2019 |

+4

Votescumulative integral” formula is “upper” + “peer monthly score”

Your solution to this problem brings no The necessary trouble. Change your mind: =sum(A$2:A2).

Mark- April 21, 2019 |