function help needed

[hotelmasters]

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

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Bondi]

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

 

[hotelmasters]

perfect, thanks.

do you know how i can lookup value that isn't precise. for example if i was
using a vlookup function is there a way to lookup a value that isn't exact,
as if i was looking up "January" but wanted to include cells that contain
either January or January '06 or January 2006?

thanks

 

[Guest]

You'd have to include something like:

ISNUMBER(SEARCH("January",A2))

Andy.