Hi everyone. Is there a big difference in the efficiency of Vlookup and
Sumif? I have a sheet with about 12,000 formulae. Currently I am using
Vlookup. If I switched to Sumif, would it be slower or faster? Thank you!

Well they are two quite different formulas

VLOOKUP is for looking up data from a different column when a match is
found in a vertical list

SUMIF is for summing values based on a condition

--
Kind Regards,
Will Riley


"Steph" wrote:

Hi everyone. Is there a big difference in the efficiency of Vlookup and
Sumif? I have a sheet with about 12,000 formulae. Currently I am using
Vlookup. If I switched to Sumif, would it be slower or faster? Thank you!

It would be different! VLOOKUP returns a value in a table for an offset from
a particular value, SUMIF adds a range where the same or an other range
equals a value, It's apples and pears.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steph" wrote in message
...
Hi everyone. Is there a big difference in the efficiency of Vlookup and
Sumif? I have a sheet with about 12,000 formulae. Currently I am using
Vlookup. If I switched to Sumif, would it be slower or faster? Thank
you!

Right, but if I'm returning a value either way, the Sumif returns the same
value. It simply adds one record, essentially returning the one and only
record it finds.


"Bob Phillips" wrote in message
...
It would be different! VLOOKUP returns a value in a table for an offset
from
a particular value, SUMIF adds a range where the same or an other range
equals a value, It's apples and pears.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steph" wrote in message
...
Hi everyone. Is there a big difference in the efficiency of Vlookup and
Sumif? I have a sheet with about 12,000 formulae. Currently I am using
Vlookup. If I switched to Sumif, would it be slower or faster? Thank
you!

If it's only one value you are looking to return.. it begs the question why
you are
using SUMIF at all
--
Kind Regards,
Will Riley


"Steph" wrote:

Right, but if I'm returning a value either way, the Sumif returns the same
value. It simply adds one record, essentially returning the one and only
record it finds.


"Bob Phillips" wrote in message
...
It would be different! VLOOKUP returns a value in a table for an offset
from
a particular value, SUMIF adds a range where the same or an other range
equals a value, It's apples and pears.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steph" wrote in message
...
Hi everyone. Is there a big difference in the efficiency of Vlookup and
Sumif? I have a sheet with about 12,000 formulae. Currently I am using
Vlookup. If I switched to Sumif, would it be slower or faster? Thank
you!