I have data in a separate workbook.
3 columns - Date/Production Line / Hours
In another book, I have sumproducts to sort out the data for me.
I write the sumproduct formula, and it works perfectly.
I save both the data book, and other books. and re-open
My cells with the sumproduct formulas in it, go from 8 ( which is correct ) to something like 1472.8.
I am using the ranges from A1:A65000, instead of using A:A,. which I think I cannot use in Sumproducts formulas.
Any ideas on why it works, and then doesnt?
3 columns - Date/Production Line / Hours
In another book, I have sumproducts to sort out the data for me.
I write the sumproduct formula, and it works perfectly.
I save both the data book, and other books. and re-open
My cells with the sumproduct formulas in it, go from 8 ( which is correct ) to something like 1472.8.
I am using the ranges from A1:A65000, instead of using A:A,. which I think I cannot use in Sumproducts formulas.
Any ideas on why it works, and then doesnt?