Need help with creating a formula

J

Jodie

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.
 
J

Jodie

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.
 
Top