Sum of 12 cells
You say you want to find the first 12 non-empty cells in a row, but if there
are not 12, then average etc, thereafter repeat this excercise another two
times. However if you find the first 12 non-empty cells, then there cannot
be empty cells?
Are you actually saying that you want a formula that will sum 12 adjacent
cells, on conditions that they are all not empty, else average these 12 cells
and multiply the result by 12. Iow, sum(C12:N12) if all are not empty. If
there are empty cells in C12:N12, then average the non empty cells in C12:N12
and multiply by 12.
--
Hth
Kassie Kasselman
Change xxx to hotmail
"BillyRogers" wrote:
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
arent 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
|