I'm using the vlookup to capture financial data from another worksheet. The problem is that some names are listed more than once. I need to sum up all salaries. Ex John Doe listed 3 time with $5, $3, and $2 and need to add them together.
hotpepper, there's nothing wrong with what you said, but I'll mention that when I give sumif examples I usually add the $ anchors, having myself been beaten up by that so many countless times. ( Generally, I try to condition myself to add them immediately after constructing a SUMIF. Too bad you can't type $ while entering the formula (that is, when you navigate the ranges). )