Getting a cell to return the value above it plus 1 if another cell is true

MaCabe

I am trying to apply a formula to the whole column that is a countif but it returns an error. I want the cells in [wheel id] to count the number of trues in [new wheel] but only that row. Picture attached. This only returns the overall total of trues.

parulmishra

Hi @MaCabe

You need to, give an additional condition to count only thos rows which are above your existing row something likes this

=COUNTIFS(New Wheel:New wheel, Row:Row, @cell <= Row@row, New Wheel:New wheel,@cell,=1)

parulmishra

Hi @MaCabe

You need to, give an additional condition to count only thos rows which are above your existing row something likes this

=COUNTIFS(New Wheel:New wheel, Row:Row, @cell <= Row@row, New Wheel:New wheel,@cell,=1)