countblanks

Question

need a formula for counting blank cells in a column of numbers.

Answer 1

Re: not really blank

You will have to provide some detailed examples of what you need.
I am bowing out of this question. Good Luck.

Nothing Left to Lose

Answer 2

Hi,thanks for looking at the question but what i need is to count and number empty cells in a column. i have a formula if(or (B$2:B$50=H$1,C$2:C$50=H$1, these are columns for lottery results to tell how many skips between the same number hit again.i would like the empty cell have numbers 1,2,3,4,5 and so on if the number comes in i would like to have the skips numbered. after it hits re-start the count skips again.

Answer 3

Re: blanks (no formulas) in a range.

For a single column, you might prefer...

=ROWS(range)-COUNTA(range)

'---

Nothing Left To Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 4

Hello gizmolucy53,

Welcome to Microsoft Community.

I am a Microsoft user just like you, I hope you are doing well?

Formula for counting blank cells in a column of numbers is COUNTBLANK(range)

The COUNTBLANK function syntax has the following arguments: Range    Required. The range from which you want to count the blank cells.

Example: =COUNTBLANK(A2:B4)

Source: https://support.microsoft.com/help/6a92d772-675c-4bee-b346-24af6bd3ac22

Please let me know if you need more assistance.

Give back to the Community, Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Warm Regards

Answer 5

hi guizmolucy53,

=countblank(range) should do what you're looking for. See this support article for extra details.

Let us know if that works for you

Cheers