function help needed
 

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

function help needed
 

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

function help needed
 

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

function help needed
 

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

"Andy" wrote:

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

function help needed
 

You'd have to include something like:

ISNUMBER(SEARCH("January",A2))

Andy.

"hotelmasters" wrote in message
...
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

"Andy" wrote:

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