I am getting a #VALUE error when trying to add a series of data

Does your formula look something like this:

=A1+B1+C1

If you get a #VALUE! error from a formula like that it usually means that at
least one of the referenced cells contains a TEXT entry.

Use the SUM function instead, it ignores text:

=SUM(A1:C1)

--
Biff
Microsoft Excel MVP


"dpridemore" wrote in message
...
I am getting a #VALUE error when trying to add a series of data in
different
cells.

Apparently this is due to an "inconsistent formula" with others in the
same
area of the worksheet.

I have a list of data that I am accessing through IF, AND, and VLOOKUP
functions. The cell in one column will not show any "inconsistent
formula"
errors and provides the correct data. When the formula is moved two cells
to
the right and the VLOOKUP function adjusted by 2 columns to make sure it
picks up the correct data then the "inconsistent formula" error is shown.

This is happening on three columns in the worksheet. The good column will
pick up data from the table at column 14. The second will pick up on 11.
The
third on column 10. The third on column 16.

Any help would be greatly appreciated.