If I have several products in rows and the months of the year in the columns
(the data in the columns is the sales quantity for each month) and I want to
count over from the right to the 25th cell to see if that particular cell and
all the cell's to the 25th cell's left are blank...if this is true I want to
place an "x" in the formula cell.

Basically what this formula would do would tell me if the product is a
mature product or not. A mature product is categorized as having sales for
greater than 24 months and a new product is categorized as having sales only
within 24 months or less. My spreadsheet will have several years of data in
it by month.

thanks for the help in advance!!!!
Jeff

this would count entries in cells as you requested (cell entry being ae10 or
column 31), so the count was from a10:f10

=COUNTA(OFFSET(AE10,0,-25,1,1):OFFSET(AE10,0,-(COLUMN(AE10)-1),1,1))

"jzachar" wrote:

> If I have several products in rows and the months of the year in the columns
> (the data in the columns is the sales quantity for each month) and I want to
> count over from the right to the 25th cell to see if that particular cell and
> all the cell's to the 25th cell's left are blank...if this is true I want to
> place an "x" in the formula cell.
>
> Basically what this formula would do would tell me if the product is a
> mature product or not. A mature product is categorized as having sales for
> greater than 24 months and a new product is categorized as having sales only
> within 24 months or less. My spreadsheet will have several years of data in
> it by month.
>
> thanks for the help in advance!!!!
> Jeff