If statement with multiple conditions

[robstark]

It's been awhile for me... what I need is to setup a formula to look for date in one cell then if the condition is met have it total the number in the next column. In the example table below the formula I'm trying to solve is the 'Total" column. TIA

Name	Month	Number		Month	Total
Test A	Apr-21	250		Apr-21	300
Test B	May-21	100		May-21	100
Test C	Apr-21	50		Jun-21	50
Test D	Jun-21	50

 

[Fluff]

Are your dates real dates or text?
If real dates are they all the 1st of the month?

 

[robstark]

They are real dates, mm/1/year, so yes the first of the month

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	Name	Month	Number		Month	Total
2	Test A	Apr-21	250		Apr-21	300
3	Test B	May-21	100		May-21	100
4	Test C	Apr-21	50		Jun-21	50
5	Test D	Jun-21	50
Results

Cell Formulas
Range	Formula
F2:F4	F2	=SUMIFS(C:C,B:B,E2)