Hi

Have a look at the SUMIF function:
=SUMIF(A2:A50,"Petty Cash",B2:B50)

Hope this helps.
Andy.

"hotelmasters" wrote in message
...
If i have a table with similar names and values next to the name, how can
I
sum up all of those numbers similar to a vlookup function where i could
say
"total all numbers 1 column away from 'petty cash'"?
i.e

Petty Cash 5,575
Check 2000
Check 1575
Petty Cash 4075