| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum cells based on value of other cells
I've tried finding the answer for this by searching, but didn't have
luck. I have a table where column "A" contains a single character or empty. Column "B" has a dollar value. I need to sum all "B" cells where "A" has a specific letter, but can't figure out the right way to do this. Thanks in advance, Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum cells based on value of other cells
Try something like this:
=SUMIF(A1:A10,"A",B1:B10) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Chris" wrote in message ... I've tried finding the answer for this by searching, but didn't have luck. I have a table where column "A" contains a single character or empty. Column "B" has a dollar value. I need to sum all "B" cells where "A" has a specific letter, but can't figure out the right way to do this. Thanks in advance, Chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum cells based on value of other cells
Try this:
=SUMIF(A1:A100,"A",B1:B100) Wiill sum column B where column A = "A". Or, use a cell to hold the criteria: D1 = A =SUMIF(A1:A100,D1,B1:B100) -- Biff Microsoft Excel MVP "Chris" wrote in message ... I've tried finding the answer for this by searching, but didn't have luck. I have a table where column "A" contains a single character or empty. Column "B" has a dollar value. I need to sum all "B" cells where "A" has a specific letter, but can't figure out the right way to do this. Thanks in advance, Chris |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum cells based on value of other cells
Worked perfectly, thanks!
On Mar 2, 1:31 pm, "T. Valko" wrote: Try this: =SUMIF(A1:A100,"A",B1:B100) Wiill sum column B where column A = "A". Or, use a cell to hold the criteria: D1 = A =SUMIF(A1:A100,D1,B1:B100) -- Biff Microsoft Excel MVP "Chris" wrote in message ... I've tried finding the answer for this by searching, but didn't have luck. I have a table where column "A" contains a single character or empty. Column "B" has a dollar value. I need to sum all "B" cells where "A" has a specific letter, but can't figure out the right way to do this. Thanks in advance, Chris |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum cells based on value of other cells
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Chris" wrote in message ... Worked perfectly, thanks! On Mar 2, 1:31 pm, "T. Valko" wrote: Try this: =SUMIF(A1:A100,"A",B1:B100) Wiill sum column B where column A = "A". Or, use a cell to hold the criteria: D1 = A =SUMIF(A1:A100,D1,B1:B100) -- Biff Microsoft Excel MVP "Chris" wrote in message ... I've tried finding the answer for this by searching, but didn't have luck. I have a table where column "A" contains a single character or empty. Column "B" has a dollar value. I need to sum all "B" cells where "A" has a specific letter, but can't figure out the right way to do this. Thanks in advance, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Linear Mode
