| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of rows in different columns
Help!
I have two columns A and B. A1 has a large number of rows with fruit. I want one cell to sum all the values in B if A is a specific text. For example, when column A states Apples, I want the sum of column B for the rows that Apples appear on column A. A B Kiwi 20 Apples 12 Pears 5 Apples 10 .... Sum of Apples = 22 The reason why I don't sum it is that there is a large number of rows and I need that value for another worksheet. Any help? Thanks much out there? -- en |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of rows in different columns
Hi
=SUMIF(A1:A4,"Apples",B1:B4) Regards, Per On 4 Okt., 05:10, envy wrote: Help! I have two columns A and B. *A1 has a large number of rows with fruit. *I want one cell to sum all the values in B if A is a specific text. *For example, when column A states Apples, I want the sum of column B for the rows that Apples appear on column A. A * * * * * * B Kiwi * * * * 20 Apples * * 12 Pears * * * 5 Apples * * 10 ... Sum of Apples = 22 The reason why I don't sum it is that there is a large number of rows and I need that value for another worksheet. *Any help? Thanks much out there? -- en |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of rows in different columns
Here's a couple more...
=SUM(SUMIF(A1:A5,{"Apples"},B1:B5)) =SUMPRODUCT(--(A1:A4="Apples"),B1:B4) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Per Jessen" wrote: Hi =SUMIF(A1:A4,"Apples",B1:B4) Regards, Per On 4 Okt., 05:10, envy wrote: Help! I have two columns A and B. A1 has a large number of rows with fruit. I want one cell to sum all the values in B if A is a specific text. For example, when column A states Apples, I want the sum of column B for the rows that Apples appear on column A. A B Kiwi 20 Apples 12 Pears 5 Apples 10 ... Sum of Apples = 22 The reason why I don't sum it is that there is a large number of rows and I need that value for another worksheet. Any help? Thanks much out there? -- en |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of rows in different columns
Ryan & per Jessen - you are awesome! Thanks for the help!!!
-- en "ryguy7272" wrote: Here's a couple more... =SUM(SUMIF(A1:A5,{"Apples"},B1:B5)) =SUMPRODUCT(--(A1:A4="Apples"),B1:B4) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Per Jessen" wrote: Hi =SUMIF(A1:A4,"Apples",B1:B4) Regards, Per On 4 Okt., 05:10, envy wrote: Help! I have two columns A and B. A1 has a large number of rows with fruit. I want one cell to sum all the values in B if A is a specific text. For example, when column A states Apples, I want the sum of column B for the rows that Apples appear on column A. A B Kiwi 20 Apples 12 Pears 5 Apples 10 ... Sum of Apples = 22 The reason why I don't sum it is that there is a large number of rows and I need that value for another worksheet. Any help? Thanks much out there? -- en |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
Linear Mode
