=countif

inon rettig

i am trying to count all cells that are greater then 0 but only on certain cells, not the whole column

as shown in print screen

i would also like to have a formula that shows cells in column that are greater than 0 but less than 100

what is the right formula?

thanks in advance

BullandKhmer

Is it only parent rows that you dont want counted?

If so then you could add a helper column with a column formula

=count(decedents()),

then use a countifs formula

COUNTIFS([helper]:[helper],=0,[remain]:[remain],<>0)

Then for between 0 & 100

COUNTIFS([helper]:[helper],=0,[remain]:[remain],>0,[remain]:[remain],<100)