Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Error #value
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF formula #NAME? error | Excel Worksheet Functions | |||
=IF formula #NAME? error | Excel Worksheet Functions | |||
error with formula | Excel Discussion (Misc queries) | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula error | Excel Discussion (Misc queries) |