I have a constant range of cells D831 (two periods per month) on each sheet
where I need to get the number of cells with data, and the number of blank
cells AFTER cells with data. (I don't want to include the empty cells before
the sales data starts). I need to do a projection of sales for the balance of
the year and need number of months with data and the REMAINING months without
data.
I have over 100 sheets, one for each location, and would rather not
customize the formula for each sheet as new locations are added.
Is there a formula (can't see how) or maybe a macro that would give me these
two numbers?

=COUNTA(D831)

and

=24-previous_formula

or

=COUNTBLANK(D831)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" <(E-Mail Removed)> wrote in message
news:80494155-3422-4115-9F8B-(E-Mail Removed)...
> I have a constant range of cells D831 (two periods per month) on each
sheet
> where I need to get the number of cells with data, and the number of blank
> cells AFTER cells with data. (I don't want to include the empty cells
before
> the sales data starts). I need to do a projection of sales for the balance
of
> the year and need number of months with data and the REMAINING months
without
> data.
> I have over 100 sheets, one for each location, and would rather not
> customize the formula for each sheet as new locations are added.
> Is there a formula (can't see how) or maybe a macro that would give me
these
> two numbers?

Thanks Bob,
That will include empty spaces BEFORE data that may start in March for
example.
I need something that will recognize the first cell with data, then begin
the count, and then count only empty cells to the end of the range after the
data. In this example, I would not want the cells for January and February
included.

"Bob Phillips" wrote:

> =COUNTA(D831)
>
> and
>
> =24-previous_formula
>
> or
>
> =COUNTBLANK(D831)
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "David" <(E-Mail Removed)> wrote in message
> news:80494155-3422-4115-9F8B-(E-Mail Removed)...
> > I have a constant range of cells D831 (two periods per month) on each
> sheet
> > where I need to get the number of cells with data, and the number of blank
> > cells AFTER cells with data. (I don't want to include the empty cells
> before
> > the sales data starts). I need to do a projection of sales for the balance
> of
> > the year and need number of months with data and the REMAINING months
> without
> > data.
> > I have over 100 sheets, one for each location, and would rather not
> > customize the formula for each sheet as new locations are added.
> > Is there a formula (can't see how) or maybe a macro that would give me
> these
> > two numbers?
>
>
>