Trying to speed up my workbook after reading that sumifs are much quicker than sumproduct, however......
SUMIF works - I get the correct result
Please Login or Register to view this content.
SUMIFS gives me a #VALUE error.
As I've only used a single condition in my SUMIFS formula, isn't it exactly the same as the SUMIF?
No, they don't work exactly the same..
It's likely that the 2 named ranges are not of the same dimensions.
SUMIF allows that, SUMIFS does not.
SUMIFS will only work on 1 dimensional ranges (single rows/columns).
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That's not quite true...Originally Posted by Tony Valko
Each range must be equal dimension, but they can be 2D dimesions, as long as they are both the same.
Yes, that's correct.
Must have been having a real off day yesterday - the differing range size was the reason I went for sumproduct in the first place.
And I couldn't even get the title of this thread right sumif vs sumif? Now that fixture has draw written all over it!
Thanks guys
You're welcome.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks