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