IF Statement with Sum Formula

[JubberB]

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.

 

[Joe4]

Take a look at the SUMIFS formula, which allow you to SUM based on two conditions (User and Date).

MS Excel: How to use the SUMIFS Function (WS)

This Excel tutorial explains how to use the Excel SUMIFS function with syntax and examples. The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on a single or multiple criteria.

www.techonthenet.com

 

[JubberB]

AH! Thanks! I was thinking IFS it's SUMIFS! I'll check it out and let you know. Thanks!

 

[Joe4]

You are welcome.

 

[JubberB]

Awesome! This rocks! What if I wasn my criteria to de defined as DOES NOT EQUAL [range of user names]?
THANK YOU!

 

[Joe4]

Awesome! This rocks! What if I wasn my criteria to de defined as DOES NOT EQUAL [range of user names]?

That gets a bit more complicated, but there are few ways of going about it.
Take a look at some of the suggestions proposed here: Sumifs that does not equal a range of values

 

[JubberB]

OK, here's what I don't get: SUMIFS worked perfectly on one sheet. Did the exact same thing on a new sheet and when I add a criteria range and criteria, I get no results.

 

[Joe4]

OK, here's what I don't get: SUMIFS worked perfectly on one sheet. Did the exact same thing on a new sheet and when I add a criteria range and criteria, I get no results.

You proved that it can/does work on your one sheet. So something must not be right or different on your other sheet. Check your criteria. It must match EXACTLY. Even an extra space at the end of a string is enough to make it not match the criteria.

Without any details of the details of your data and formula, it is very difficult to provide you any sort of direction.

 

[JubberB]

Got ya! I trimmed everything and pasted values and it seems to work now. Thank you!

 

[Joe4]

You are welcome. Glad it was a simple fix.