PittViper1965
New Member
- Joined
- Mar 15, 2021
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Very simple question, but I indeed do forget how to do this. I have a Worksheet with month names in A1:A12. It is called Sheetnames.
I need to pull the month name from the sheet, and extract various cell data for a summary sheet.
Currently, this is the horrible mess of a formula I have, which does NOT work, btw....
=sum(indirect("'"&Sheetnames&"'!A1:A12)&"'!"B60))
Obviously, I am trying to sum cell B60 in all sheets January through December. I am going to feel like a jerk when the first guy comes along and shows me exactly what I am doing wrong. Old foggy mind here...
I am very sure I am mostly likely messing up the syntax, and probably the " and ' as well, as my eyes are old and bad!
So, any help is appreciated.
Also, if Osvaldo P is on this board, I have lost your email address, as I had a hd malfunction, and lost all email contacts. So, if you read this, it's Jason, so, please contact me!
Thanks for the help all...
Jason
I need to pull the month name from the sheet, and extract various cell data for a summary sheet.
Currently, this is the horrible mess of a formula I have, which does NOT work, btw....
=sum(indirect("'"&Sheetnames&"'!A1:A12)&"'!"B60))
Obviously, I am trying to sum cell B60 in all sheets January through December. I am going to feel like a jerk when the first guy comes along and shows me exactly what I am doing wrong. Old foggy mind here...
I am very sure I am mostly likely messing up the syntax, and probably the " and ' as well, as my eyes are old and bad!
So, any help is appreciated.
Also, if Osvaldo P is on this board, I have lost your email address, as I had a hd malfunction, and lost all email contacts. So, if you read this, it's Jason, so, please contact me!
Thanks for the help all...
Jason