SumIf formula alteration.

[asyamonique]

Good Day,
If B:B column has dates entries all the way down with as the format of "1-Jan-2023" and B2 data is only month entry as "JANUARY"
What will be the alter on given formula below?
Thanks for the help.

=SUMIF(MASTER!B:B,B2,MASTER!D:D)

 

[Asbestos_Jen]

Are you trying to sum D:D only if the month matches January, or something else?

 

[asyamonique]

Actually fixed as below info.
Created helping column as numbered mnths.
Thx

=TEXT(D3, "mmmm")

=SUMIF(MASTER!A:A,B3,MASTER!E:E)

 

[Dave Patton]

The month is coerced within the formula to number; this may depend on your Regional Settings.

T202312a.xlsm
	A	B	C
1
2		January	1769
3
7b

Cell Formulas
Range	Formula
C2	C2	=SUMIFS(Master!D:D,Master!B:B,">="&DATE(2023,MONTH(1&B2),1),Master!B:B,"<="&EOMONTH(DATE(2023,MONTH(1&B2),1),0))