Yippy_Kiyey
Board Regular
- Joined
- Sep 28, 2008
- Messages
- 96
I have two spreadsheets:
1. Pricing_detail.xlsx
2. Profit_Analysis.xlsx
All computations are done in Pricing_detail.xlsx.
In the Profit_Analysis.xlsx, there are several fomulas using the sumif function.
Everything is good and formula works only if both worksheets are open at the time.
When I open the Profit_Anlysis.xlsx by itself and don't open the Pricing_detail, the results of the sumif formula turns into "Value".
Is that how sumif works?
Thank you so much.
Rsp
1. Pricing_detail.xlsx
2. Profit_Analysis.xlsx
All computations are done in Pricing_detail.xlsx.
In the Profit_Analysis.xlsx, there are several fomulas using the sumif function.
Everything is good and formula works only if both worksheets are open at the time.
When I open the Profit_Anlysis.xlsx by itself and don't open the Pricing_detail, the results of the sumif formula turns into "Value".
Is that how sumif works?
Thank you so much.
Rsp