Check that you don't have spaces or other invisible characters in the source cells.
You can use =LEN(Clinical!C50) etc to check that they are really empty


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Erika" wrote in message ...
|I have a formula running down 80 rows - the formula is the same just the cell
| references change. When I get to row 50 and 51 I get a value error - but
| there is no error for the other rows. What am I missing?
|
| =Clinical!C50+Logs!C50+Vehicle!C50+DQ!C50+'Trip
| Permits'!C50+Technology!C50+Admin!C50
|
| =Clinical!C51+Logs!C51+Vehicle!C51+DQ!C51+'Trip
| Permits'!C51+Technology!C51+Admin!C51
|
| Currently all of the cells in the calculation are blank but for all of the
| other formulas I get a $0 but for those 2 rows I get the error.