SUM OF SALES REVENUE BASED ON SALESPERSON AND MONTH OF THE YEAR

[meppwc]

I am lookin for a formula that will provide a sum of all sales for a particular person based on the month of the year that those sales were made
Column A is the date of all the sales for the year. (mm/dd/yyyy) Column B is a list of all the sales agent's names, and column C is the amount of each sale..
Lets say that Mike Smith made two sales that total $400 in the month of April. What would the formula be to come up with that $400 total?

 

[hagia_sofia]

E.g.

=SUMIFS(C2:C51,B2:B51,E3,A2:A51,">="&E2,A2:A51,"<="&EOMONTH(E2,0))

where E3 is the cell with an agent's name and E2 is the cell with a month (i.e. 1st of x).

 

[Joe4]

Use a SUMIFS formula where you can use criteria for both the user name and date range.
See: Excel SUMIFS date range formula - sum if between two dates

 

[AhoyNC]

Another option with the FILTER function. If you have data for more than 1 year then the formula in I2.

Book1
	A	B	C	D	E	F	G	H	I
1	Date	Agent	Amount		Agent	Month	Amount		If more than 1 year of data
2	3/1/2024	Mike Smith	88		Mike Smith	4	400		400
3	3/1/2024	Judy West	100		Judy West	4	426		426
4	3/25/2024	Sam Wilson	250		Sam Wilson	4	0		0
5	4/2/2024	Mike Smith	225
6	4/8/2024	Mike Smith	175
7	4/25/2024	Judy West	326
8	4/30/2024	Judy West	100
9	5/5/2024	Mike Smith	231
10	5/2/2024	Sam Wilson	455
Sheet1

Cell Formulas
Range	Formula
G2:G4	G2	=SUM(FILTER($C$2:$C$10,($B$2:$B$10=E2)*(MONTH($A$2:$A$10)=F2),0))
I2:I4	I2	=SUM(FILTER($C$2:$C$10,($B$2:$B$10=E2)*(MONTH($A$2:$A$10)=F2)*(YEAR($A$2:$A$10)=2024),0))

 

[meppwc]

Thank you both for the suggestions and solution. I appreciate it greatly