Inconsistent formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add a column H5. I keep getting the message "inconsistent forumla"
or "value".

The formula I'm using in cell H26 is: SUM(H5:H24)

H5 has some cells that are empty and some that are filled. Is this why? If
so, how do I add a column that has some empty cells?

Thanks again for your help. I really appreciate the responses.
 
Check your cell formats. In order for your formula to work, all th
cells must be in numbers format. Some of your cells might have texts i
them which is the reason why you are getting an error.

To determine which cells are not numbers, enter the formula

=isnumber(H5)

in cell I5 and copy down to cell I24.

All cells then in I5:I24 that returns "FALSE" will tell you which cell
in Column H are not in numbers format.

Hope this will help you out.
 
H5 has the following formula:
=IF(G5=1,"29.99",IF(G5=2,"39.99",IF(G5=3,"49.99","")))

That formula is copied down to H24 (Some of the cells are empty due to the
formula.)

H26 has the following formula: =SUM(H5:H24)

But I get a value of 0.00 in H26. I formated all the cells as numbers, but
it doesn't change the outcome. I formatted the column as numbers, and still
it doesn't change from 0.00. There are a total of 10 entries in H5:H24 for a
total of $409.90.

Any ideas?
 
Thank you! Your reply got me to thinking about what could be text. So I
deleted the quotation marks around the numbers in the formula, and that did
it! It works!

Thank you so much for your help.
 
Back
Top