I'd like to see an example to solve a similar problem

Aaron Surber

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.

Screen Shot 2022-10-17 at 7.49.36 PM.png

This sheet is where I'm trying to summarize.

Screen Shot 2022-10-17 at 7.49.48 PM.png

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.

Michael Culley

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})

Aaron Surber

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?

Genevieve P.

Hi @Aaron Surber

Can you post a screen capture of the formula in your sheet, open in a cell?