hotelmasters wrote:
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

Hi,

Maybe you can use something like:

=SUMIF(A1:A4,"Petty Cash",B1:B4)

If you have description in column a and amount in b

Regards,
Bondi