Which calculation is faster??

K

kyddrivers

Board Regular
Joined
Mar 22, 2013
Messages
59
Office Version
  1. 365
Platform
  1. Windows
Just looking for opinions...

Would an HLookup or a SumIf array be faster??

Thanks!!
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

D
  • Question
Quickest Calculation formula for cell with 15 different possibilities
Replies
3
Views
116
smozgur
smozgur
E
  • Solved
Unexpected flaw in WORKDAY formula to calculate date
Replies
7
Views
406
KRice
K
U
  • Question
Checkboxes vs Drop Downs
2
Replies
14
Views
202
My Aswer Is This
My Aswer Is This
P
  • Question
How best to copy a hidden sheet with a multiple formulas to create a multiple new sheets
Replies
7
Views
288
PaulskinX1
P
S
  • Question
Auditing Dynamic Array Events
Replies
1
Views
48
awoohaw
awoohaw

Forum statistics

Threads
1,216,028
Messages
6,128,395
Members
449,446
Latest member
CodeCybear

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top