I have a 12 spreadsheets with 1100 lines being given to me from different
people...each person must put a H,L or M in a particular cell, I have a
formula to calculate H,L and M into values. Example: h=15, L=24, m=30. On
some of my 12 spreadsheets i have h,L, or M blank which returns "0" --
I need to consolidate these 12 spreadsheets into a master sheet calculating
h,L, and M then averaging those values. This works as long as the spreadsheet
has an h, l or m in the cell.
My formulas returns a "False" message when it finds a zero value.
Initially, I would think to just delete the formula cell returning zero;
however with 1100 lines and 12 spreadsheets it would be an impossible task.
How can I create a formula to ignore the cells that return a value of "0"?
I need to make sure that the zero isn't calculated so my average will come
out right.

may we see your formula?

"cenendra" wrote:

I have a 12 spreadsheets with 1100 lines being given to me from different
people...each person must put a H,L or M in a particular cell, I have a
formula to calculate H,L and M into values. Example: h=15, L=24, m=30. On
some of my 12 spreadsheets i have h,L, or M blank which returns "0" --
I need to consolidate these 12 spreadsheets into a master sheet calculating
h,L, and M then averaging those values. This works as long as the spreadsheet
has an h, l or m in the cell.
My formulas returns a "False" message when it finds a zero value.
Initially, I would think to just delete the formula cell returning zero;
however with 1100 lines and 12 spreadsheets it would be an impossible task.
How can I create a formula to ignore the cells that return a value of "0"?
I need to make sure that the zero isn't calculated so my average will come
out right.

Instead of returning 0, get your formula to return an empty string "", and
then the AVERAGE function will ignore it.
--
David Biddulph

"cenendra" wrote in message
...
I have a 12 spreadsheets with 1100 lines being given to me from different
people...each person must put a H,L or M in a particular cell, I have a
formula to calculate H,L and M into values. Example: h=15, L=24, m=30.
On
some of my 12 spreadsheets i have h,L, or M blank which returns "0" --
I need to consolidate these 12 spreadsheets into a master sheet
calculating
h,L, and M then averaging those values. This works as long as the
spreadsheet
has an h, l or m in the cell.
My formulas returns a "False" message when it finds a zero value.
Initially, I would think to just delete the formula cell returning zero;
however with 1100 lines and 12 spreadsheets it would be an impossible
task.
How can I create a formula to ignore the cells that return a value of "0"?
I need to make sure that the zero isn't calculated so my average will come
out right.