Anyone know how to sum a series of Vlookups in Excel?
Could you give an example? I’m having a hard time visualizing what you want to do. (Of course, I have a hard time visualizing most things, so it aint you:))
Put the VLOOKUP formulas in separate cells, then add the contents of those cells together with a formula as normal?
Or if you really, really wanted to (make the formula complex, that is) you could put each VLOOKUP in parantheses with an addition between them. Example:
=(@VLOOKUP(yada yada yada))+(@VLOOKUP(yada yada yada))+ etc etc etc…
mattk’s idea is the better way to do it, though. Easier to debug if there is a problem.
Regards.
Any of you guys use the conditional sum wizard? Cool, but with some rather odd limitations.
I haven’t really used the wizard much, but I use the SUMIF function (which is one of the functions the wizard helps you create) all the time. It’s great for summing numbers in large databases if you don’t want to build a whole pivot table. And it’s a lot cleaner to use than the DSUM fucntion. In fact, I was just using it this morning to total sales data for specific product lines from a database of all of our products (2,500+). God, I’m such an Excel geek.