Using SUMIF function in combination with TEXT function

Question

I have a table with two columns: Date and Cost. The date is formatted in "XX/XX/XXXX". The cost is just a number value.

I have a second table where I have the dates listed out in month ("January", "February", "March"...) in columns. What I would like to achieve is to do a SUMIF formula where the date matches the month in column. This is what I have tried so far:

=SUMIF(B:B,TEXT(A:A,"MMMM"),D1)

In this case B:B = Cost , A:A = Date, D1 = "January". However this didn't work.

Can you please advise.

Thank you

Answer 1

It seems that B:B is your summing range, in that case,

Try

=SUMIF(TEXT(A:A,"MMMM"),D1,B:B)

Syntax for SUMIF: SUMIF(range, criteria, [sum_range])

or

=SUMIFS(B:B,TEXT(A:A,"MMMM"),D1)

Syntax for SUMIF: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)