Need help with creating a formula
 

I need to create a formula that adds the values that are in column C for each
row that contains a certain business name found in column B. Please help!
Thanks.
--
Jodie

Need help with creating a formula
 

Try this:

=SUMIF(B:B,"some_name",C:C)

Biff

"Jodie" wrote in message
...
I need to create a formula that adds the values that are in column C for
each
row that contains a certain business name found in column B. Please help!
Thanks.
--
Jodie

Need help with creating a formula
 

Thank you so much for the quick response, but it doesn't work. I just get a
value of 0. Maybe I'm misunderstanding because I'm quite the novice. Let's
say the business name is Business1. I would type your formula as follows:
=SUMIF(B:B,"Business1",C:C)
I tried that, but the sum is always 0. Am I missing something? Thanks.
--
Jodie


"T. Valko" wrote:

Try this:

=SUMIF(B:B,"some_name",C:C)

Biff

"Jodie" wrote in message
...
I need to create a formula that adds the values that are in column C for
each
row that contains a certain business name found in column B. Please help!
Thanks.
--
Jodie

Need help with creating a formula
 

NEVER MIND - I'M AN IDIOT. It works great! Thank you VERY much!!!
--
Jodie


"Jodie" wrote:

I need to create a formula that adds the values that are in column C for each
row that contains a certain business name found in column B. Please help!
Thanks.
--
Jodie

Need help with creating a formula
 

NEVER MIND - I'M AN IDIOT.

Hey, we have something in common! <VBG

You're welcome!

Biff

"Jodie" wrote in message
...
NEVER MIND - I'M AN IDIOT. It works great! Thank you VERY much!!!
--
Jodie


"Jodie" wrote:

I need to create a formula that adds the values that are in column C for
each
row that contains a certain business name found in column B. Please
help!
Thanks.
--
Jodie