I have researched and even attempted other suggested fixes for this problem, but am still unable to find what I'm doing wrong here.
I have been working on forecasting our clinic system physicians' encounter numbers for the next year and wanted to sum all of the physicians' counts for the entire clinic system by month. For some silly reason I could not remember the password I used to protect my original worksheets, so I copied and pasted my worksheets into a new workbook and all numbers and formulas appear to have copied over correctly and accurately. I have included several formulas that were a little bit more complex (for my level at least) such as:
=(FORECAST(U18,IF($A$21:$T$21>150,$A$21:$T$21),IF($A$21:$T$21>150,$A$18:$T$18)))*1.1
to forecast future numbers excluding figures below 150 (for this particular physician). I've checked and double checked formatting, formulas, etc., but still at the bottom of my columns when I attempt to sum, it returns several columns of accurate sums followed by several columns of just wrong numbers. When you attempt to re-calculate the sum formula by clicking on the cell and hitting enter again, a 0 pops up.
Here is what I've tried so far:
Formatting cells to hold numerical values.
Formatting cells to hold general values.
Editing Text to Columns and removing delimiters (recommended by an admin on a previous post).
Something new I just found out as I attempted to re-run a formula - when I click on the cell containing the formula above and hit enter to re-run the formula, 0 appears. It seems like all of the formulas return 0 now that I've copied the worksheets over.
The fact that I copied a protected sheet over to a new workbook might have something to do with it.
I might have to just re-do the entire workbook. Why didn't I just write the password down!?
I have been working on forecasting our clinic system physicians' encounter numbers for the next year and wanted to sum all of the physicians' counts for the entire clinic system by month. For some silly reason I could not remember the password I used to protect my original worksheets, so I copied and pasted my worksheets into a new workbook and all numbers and formulas appear to have copied over correctly and accurately. I have included several formulas that were a little bit more complex (for my level at least) such as:
=(FORECAST(U18,IF($A$21:$T$21>150,$A$21:$T$21),IF($A$21:$T$21>150,$A$18:$T$18)))*1.1
to forecast future numbers excluding figures below 150 (for this particular physician). I've checked and double checked formatting, formulas, etc., but still at the bottom of my columns when I attempt to sum, it returns several columns of accurate sums followed by several columns of just wrong numbers. When you attempt to re-calculate the sum formula by clicking on the cell and hitting enter again, a 0 pops up.
Here is what I've tried so far:
Formatting cells to hold numerical values.
Formatting cells to hold general values.
Editing Text to Columns and removing delimiters (recommended by an admin on a previous post).
Something new I just found out as I attempted to re-run a formula - when I click on the cell containing the formula above and hit enter to re-run the formula, 0 appears. It seems like all of the formulas return 0 now that I've copied the worksheets over.
The fact that I copied a protected sheet over to a new workbook might have something to do with it.
I might have to just re-do the entire workbook. Why didn't I just write the password down!? 
