Sum a column of Income figures related to a text criteria in an adjacent column.

[Gerry Hunt]

I need a formula to examine Column “O” in my spreadsheet for the criteria “Apr-21” and then to enter an adjacent, related Column “J” and add up the monetary value for each instance of Apr-21 in Column “O” thereby providing a total value for Apr-21 in another cell – lets call it “INCOME C4”. I have used the following to no avail:
=SUMIF(CONSULTATIONS!O4:O200,"=Apr-21",CONSULTATIONS!J4:J200) but it just provides a monetary value figure for the first instance of Apr-21 in Column O.
If you can help - THANK YOU - so far Defeated.

 

[KRice]

Note the syntax for the criteria...you don't need the equals sign. Also, check for your date formats. Apr-21 is understood to be April 21, 2021...the current year.

MrExcel20210409.xlsm
	J					O
1						8
2
3	Range to Sum					Criteria
4	1					1/1/2021
5	2
6	3					21-Apr
7	4
8	5					4/21/2021
9	6
10	7
11	8
12	9					4/21/2019
13	10
CONSULTATIONS

Cell Formulas
Range	Formula
O1	O1	=SUMIF(O4:O13,"Apr-21",J4:J13)

 

[etaf]

is this a date thats formatted as APR-21
and so many dates in APR , 1st to 30th
you may then need a SUMIFS()

=SUMIF(CONSULTATIONS!O4:O200,">=&"1-Apr-21",CONSULTATIONS!J4:J200)

=SUMIFS(CONSULTATIONS!J4:J200,CONSULTATIONS!O4:O200,">="&DATEVALUE("1-Apr-21"),CONSULTATIONS!O4:O200,"<="&DATEVALUE("30-Apr-21"))