Error when using SUMIF in 2013
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
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
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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
edit: Heh, exactly the same answer
Please Login or Register to view this content.
so let me give also another one - you can use array formula (accept with Ctrl+shift+Enter rather than just Enter):
Looks similar to original one, doesnt it ?Please Login or Register to view this content.
Last edited by Kaper; 01-09-2014 at 07:43 AM. Reason: added another solution wit array formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks