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

The answer would heavily depend on your data types. Are your values actual dates formatted? Or text values? In both tables — JvdV
– JvdV, Commented Nov 9, 2019 at 16:45
@JvdV The A Column of "Date" is date formatted as mentioned (XX/XX/XXXX e.g. 11/09/2019). The D1 field is a text (/general) value of "January" as an example. — Revokez
– Revokez, Commented Nov 9, 2019 at 16:49

Terry W · Accepted Answer · 2019-11-09 20:13:42Z

0

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], ...)

answered Nov 9, 2019 at 20:13

Terry W

3,2872 gold badges10 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Revokez Over a year ago

Unfortunately I've tried this and it doesn't work. It's returning a generic error of 'There's a problem with this formula'.

Terry W Over a year ago

@Revokez could you please edit your post to include some sample data from your Column A, B and D, and demonstrate the exptected output?

Collectives™ on Stack Overflow

Using SUMIF function in combination with TEXT function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related