excel statistics the number of non-blank cells

Consult.Region B2 to the H10.In the region where not all cells are all digital, some are blank.I would like to H11 on the statistics, this area where a total number of cells in a non-empty, only statistics cell number, not statistical data into cells.Is there such a feature? If so, ask how.Thank you.

= counta (b2:h10)

= counta (B2:H10) = sumproduct (B2:H10 “”)

there is such a blank cell A1, enter = COUNTA (B2:H10)

H11 enter the formula = COUNTA (B2:H10) is a non-empty cells COUNTBLANK is within a few statistics the number of empty cells

= COUNTA (B2:H10)

Leave a Reply