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!