I'd like to see an example to solve a similar problem
I'm trying to summarize the monthly activity of a sales person. I have the data sheet which has each person in a column, a parent row of the month, and child rows for each new week. What is a formula that I could utilize to summarize the information by sales person by month?
I've attached screen shots of the sheets I'm referencing. The first sheet is the data sheet.
This sheet is where I'm trying to summarize.
Yes, I can create a formula that references the specific cell, but I'd like to create a summary sheet formula similar to an IF THEN, which states "If the month is Jan AND the sales person is X" Then the returned value is Y
Thank you.
Answers

If you want to keep your setup the way it is I would create a hidden column called parent. Then I would create a column formula that just says =PARENT(Week@row)
Then on your other sheet you would do a sumif formula like this:
=sumif({parent column},"June",{Andrea Friske})

Thanks. This is coming up as unparseable. Is there another way you would setup the data to get the information I'm looking to receive?

Can you post a screen capture of the formula in your sheet, open in a cell?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!