Forum Discussion
Maddy1010
Aug 21, 2022Brass Contributor
sumif(calc! formula...
Hi there. I have just inherited a file. It's basically a year-on-year comparison. The formula in English is: If the month and year is, for example, July 2022, return the revenue for that month (n...
- Aug 21, 2022
You have 8 worksheets here
and the Calc is with very hidden flag. You shall change it here first, on hidden or visible.
Maddy1010
Aug 21, 2022Brass Contributor
I have. No response so far. I was hoping this community will know what =Calc! formula is all about. I thought it mightve been referencing a cell, but nothing has shown up when I search for it.
Detlef_Lewin
Aug 21, 2022Silver Contributor
- Maddy1010Aug 21, 2022Brass ContributorI have unhidden everything and there is no worksheet Calc.
- SergeiBaklanAug 21, 2022Diamond Contributor
You have 8 worksheets here
and the Calc is with very hidden flag. You shall change it here first, on hidden or visible.
- Maddy1010Aug 21, 2022Brass ContributorI never knew about this veryhidden business before! Now I know and was able to open it!! Thank you!!! xx