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.
Detlef_Lewin
Aug 21, 2022Silver Contributor
Consider asking the person you inherited the workbook from for the workbook protection password.
- Maddy1010Aug 21, 2022Brass ContributorI 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_LewinAug 21, 2022Silver Contributor
- Maddy1010Aug 21, 2022Brass ContributorI have unhidden everything and there is no worksheet Calc.