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!