kyddrivers
Board Regular
- Joined
- Mar 22, 2013
- Messages
- 64
- Office Version
- 365
- Platform
- Windows
Just looking for opinions...
Would an HLookup or a SumIf array be faster??
Thanks!!
Would an HLookup or a SumIf array be faster??
Thanks!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Which calculation is faster??
- Thread starter kyddrivers
- Start date
RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 43,495
- Office Version
- 365
- Platform
- Windows
- MacOS
They're different things. HLOOKUP will look up and return one value, whereas SUMIF will add values based on criteria. If there will only be one matching value, I would expect HLOOKUP to be faster.
Upvote
0
Similar threads
- Question
