Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groupings
Greetings,
I have a chart that looks a little like this: a b 1 bob 1 2 joe 1 3 harry 2 4 joe 2 5 bob 1 ....etc. Is it possible for me to have a cell that is a sum of every cell in the column "b" where the name in column "a" is "joe"? In the above example, the correct answer would be 3 (because b2 plus b4). Thanks in advance! Regards, Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groupings
Jason
you need to use SUMIF For example: =SUMIF(A:A,"bob",B:B) Regards Trevor "Jason" wrote in message ... Greetings, I have a chart that looks a little like this: a b 1 bob 1 2 joe 1 3 harry 2 4 joe 2 5 bob 1 ...etc. Is it possible for me to have a cell that is a sum of every cell in the column "b" where the name in column "a" is "joe"? In the above example, the correct answer would be 3 (because b2 plus b4). Thanks in advance! Regards, Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groupings
On Fri, 30 Jan 2004 19:56:11 GMT, Jason wrote:
SumIf will do this for you: =SUMIF(A1:A5,"joe",B1:B5) I have a chart that looks a little like this: a b 1 bob 1 2 joe 1 3 harry 2 4 joe 2 5 bob 1 ...etc. Is it possible for me to have a cell that is a sum of every cell in the column "b" where the name in column "a" is "joe"? In the above example, the correct answer would be 3 (because b2 plus b4). --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groupings
Hi Jason
That's exactly what a Pivot Table in its simplest form does. See http://www.cpearson.com/excel/pivots.htm on how to set it up. -- HTH. Best wishes Harald Followup to newsgroup only please. "Jason" wrote in message ... Greetings, I have a chart that looks a little like this: a b 1 bob 1 2 joe 1 3 harry 2 4 joe 2 5 bob 1 ...etc. Is it possible for me to have a cell that is a sum of every cell in the column "b" where the name in column "a" is "joe"? In the above example, the correct answer would be 3 (because b2 plus b4). Thanks in advance! Regards, Jason |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groupings
Jason wrote:
Greetings, I have a chart that looks a little like this: a b 1 bob 1 2 joe 1 3 harry 2 4 joe 2 5 bob 1 ...etc. Is it possible for me to have a cell that is a sum of every cell in the column "b" where the name in column "a" is "joe"? In the above example, the correct answer would be 3 (because b2 plus b4). {=SUM((A1:A5="joe")*B1:B5)} Hi, this is an array formula, so don't place the brackets {} when typing, enter the formula not by simply pressing enter, instead you must press CTRL+SHIFT+ENTER. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Groupings and inconsistencies | Excel Discussion (Misc queries) | |||
Sorting within Groupings | Excel Discussion (Misc queries) | |||
Variable row groupings | Excel Discussion (Misc queries) | |||
Cell Groupings | Excel Worksheet Functions | |||
Groupings within PivotTables | Excel Worksheet Functions |