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!