sumif(calc! formula...

[Maddy1010]

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 (not ytd).  The next column is basically a July 2022 -1, or July 2021.  The same goes in English, if the month and year July 2021, then return the revenue for that month. Consider the attached file:  +sumif(calc!.....I don't have an idea if this is a referenced cell (Ctrl + G doesn't show anything) or a sheet name (but I have unhidden everything)

[#2]

@Maddy1010 

Consider asking the person you inherited the workbook from for the workbook protection password.

[#3]

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.

[#4]

@Maddy1010 

You need the password to unhide the "Calc" worksheet and lots of other worksheets.

[#5]

I have unhidden everything and there is no worksheet Calc.

[#6 · Accepted solution]

@Maddy1010 

You have 8 worksheets here

and the Calc is with very hidden flag. You shall change it here first, on hidden or visible.

[#7]

I never knew about this veryhidden business before! Now I know and was able to open it!! Thank you!!! xx

[#8]

@Maddy1010 , you are welcome