COUNTBLANK
The COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, spaces, etc. are not counted. Formulas that return empty text are counted. COUNTBLANK takes just one argument, range, which must be a cell range.
SUMIF
The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
Excel formula to fill in blank cells with value above / below
- Select the area that need to be filled up
- Then “Find & Replace” -> Goto(S). Then select “Blanks” and click on “GoTo”
Then all the empty cells will be selected.
- In the formula bar type “=” and then click on the cell “B2” (If you are going to fill the blank cells with the value above)
- Press Ctrl + Enter. The values will be fill out automatically
