Error when using SUMIF in 2013

[Ian456]

I am using the following formula in Excel 2013:

=SUMIF(Text($A$10:$A$23,"ddd"),$S$2,$H$10:$H$23)

The error says I must must put an apostrophe(') first:

Can't work this out, can you help please:

FYI

$A10:$A23 is a date

$S$2 is = "Fri"

H10:H23 are Numbers to add when A10:A23 equals Fri

[:) Sixthsense :)]

Change it to sumproduct.

=SUMPRODUCT(1*(TEXT($A$10:$A$23,"ddd")=$S$2),$H$10:$H$23)

It is not an excel 2013 problem because Text() Function with multiple cells as conversion range under sumif won't do the expected multi tasking job

[XOR LX]

Hi,

The syntax of SUMIF does not allow you to do this. You'll need SUMPRODUCT, e.g.:

=SUMPRODUCT((TEXT($A$10:$A$23,"ddd")=$S$2)*$H$10:$H$23)

Regards

[Kaper]

=SUMPRODUCT((TEXT($A$10:$A$23,"ddd")=$S$2)*$H$10:$H$23)

edit: Heh, exactly the same answer

so let me give also another one - you can use array formula (accept with Ctrl+shift+Enter rather than just Enter):

=SUM(IF(TEXT($A$10:$A$23,"ddd")=$S$2,$H$10:$H$23,""))

Looks similar to original one, doesnt it ?