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?
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!