I'm good in Excel, but sometimes I get stuck. Looking for a solution for:
Column "A" contains a user names
Column "R" contains date range for an entire month
Column "S" contains a dollar amount
Here's what I would like to get:
If Column "A" = a user name list (could be 1 to 20 different user names)
AND
If Column "R" contains a specific date (Example: "R" has all dates for January, 2019)
SUM all rows where the above is true
So, if one of the user names is in column "A," and the specific date matches in "R," SUM all rows in "S"
The goal is to take one giant spreadsheet with monthly information and sum it by user group per day.
Make Sense? Then I need to get this onto one sheet for every day of last year. Results will be in a new sheet. They are on the same sheet in the example listed below.
Thanks!
EDIT:
More clarification:
Each month is on a separate sheet.
Results will be in a separate sheet.
I have to do this for all months of last year.
Column "A" contains a user names
Column "R" contains date range for an entire month
Column "S" contains a dollar amount
Here's what I would like to get:
If Column "A" = a user name list (could be 1 to 20 different user names)
AND
If Column "R" contains a specific date (Example: "R" has all dates for January, 2019)
SUM all rows where the above is true
So, if one of the user names is in column "A," and the specific date matches in "R," SUM all rows in "S"
The goal is to take one giant spreadsheet with monthly information and sum it by user group per day.
Make Sense? Then I need to get this onto one sheet for every day of last year. Results will be in a new sheet. They are on the same sheet in the example listed below.
Thanks!
EDIT:
More clarification:
Each month is on a separate sheet.
Results will be in a separate sheet.
I have to do this for all months of last year.