How do I ignore cell values of zero?
 

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.

How do I ignore cell values of zero?
 

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.

How do I ignore cell values of zero?
 

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.