| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Creating a complicated formula | Excel Worksheet Functions | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| Creating a specific formula | New Users to Excel | |||
Linear Mode
