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.