You can upload a screencap here (it's free) and then post a link to the
screencap:

http://imageshack.us/


--
Biff
Microsoft Excel MVP


"BillyRogers" wrote in message
...
Thanks for the help Don, but I need a formula that can "figure out" which
column to start in. (hence I used the phrase "find the first non-empty
cell"
in the range.

Suppose that all the data will be in a given range say columns 10-50.
Not
all rows will start on the same columns (which represent months). There
can
be up to 36 columns (months) of data.

What the data represents is store sales. What I need is three annual
totals
for these stores. Some stores don't have a full 36 months worth of data.
Also, they didn't all start in the same month(column).

It's kind of confusing to explain. If I could attacha screen shot it
would
make it much easier to understand.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003


"Don Guillett" wrote:

Since you asked in functions, will this do it with a formula.
=IF(COUNT(A2:L2)=12,AVERAGE(A2:I2),(AVERAGE(A2:I2) *12))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BillyRogers" wrote in message
...
I need three formulas

1. Will find the first 12 non-empty cells in the range (a single row)
and
sum them, if there are not 12 non-empty cells it will average the
non-empty
cells and multiply by 12.

2. Will find the next 12 non-empty cells (13-24) and add them. If
there
are
not 12 non- empty cells in this second group, average them and multiply
by
12.

3. Will find the next 12 non-empty cells (25-36) and add them, if there
aren't 12 non-empty cells average the non-empty cells and multiply by
12.

--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003