Sum values referring to a cell with same value
Hey. I want to know what's the easiest way of doing that... I'll try to
explain, it's simple Let's say I have a table with many fruits in one cell, and the amount of them on the cell next to them. I want to sum all the "pears" that are on my table. How do I do it? e.g. A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 I want a cell that will give me 17 when the string looked for is pear (B2+B4+B6), or 11 when it looks for apple (B1+B5)... hope it was easy to understand |
Sum values referring to a cell with same value
Hi,
Try this: A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 12 Apple =SUMIF($A$1:$A$6,A12,$B$1:$B$12) 13 Pear 14 Banana and copy formula in cell B12 to B14 (in this example) Thanks, -- Farhad Hodjat "ghnogueira" wrote: Hey. I want to know what's the easiest way of doing that... I'll try to explain, it's simple Let's say I have a table with many fruits in one cell, and the amount of them on the cell next to them. I want to sum all the "pears" that are on my table. How do I do it? e.g. A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 I want a cell that will give me 17 when the string looked for is pear (B2+B4+B6), or 11 when it looks for apple (B1+B5)... hope it was easy to understand |
Sum values referring to a cell with same value
sorry my type mistake the formula is:
=SUMIF($A$1:$A$6,A12,$B$1:$B$6) Thanks, -- Farhad Hodjat "Farhad" wrote: Hi, Try this: A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 12 Apple =SUMIF($A$1:$A$6,A12,$B$1:$B$12) 13 Pear 14 Banana and copy formula in cell B12 to B14 (in this example) Thanks, -- Farhad Hodjat "ghnogueira" wrote: Hey. I want to know what's the easiest way of doing that... I'll try to explain, it's simple Let's say I have a table with many fruits in one cell, and the amount of them on the cell next to them. I want to sum all the "pears" that are on my table. How do I do it? e.g. A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 I want a cell that will give me 17 when the string looked for is pear (B2+B4+B6), or 11 when it looks for apple (B1+B5)... hope it was easy to understand |
Sum values referring to a cell with same value
No problem mate! Thanks =)
I forgot about the SUMIF function... thanks =) "Farhad" wrote: sorry my type mistake the formula is: =SUMIF($A$1:$A$6,A12,$B$1:$B$6) Thanks, -- Farhad Hodjat "Farhad" wrote: Hi, Try this: A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 12 Apple =SUMIF($A$1:$A$6,A12,$B$1:$B$12) 13 Pear 14 Banana and copy formula in cell B12 to B14 (in this example) Thanks, -- Farhad Hodjat "ghnogueira" wrote: Hey. I want to know what's the easiest way of doing that... I'll try to explain, it's simple Let's say I have a table with many fruits in one cell, and the amount of them on the cell next to them. I want to sum all the "pears" that are on my table. How do I do it? e.g. A B 1 apple 5 2 pear 10 3 banana 8 4 pear 6 5 apple 6 6 pear 1 I want a cell that will give me 17 when the string looked for is pear (B2+B4+B6), or 11 when it looks for apple (B1+B5)... hope it was easy to understand |
All times are GMT +1. The time now is 02:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com