software

Hi

I have a workbook with 2 sheets.

In sheet 1 I have 2 colums. Colum A containing names, colum B containing
numbers.

On sheet 2 I would like to make a function that gives me the sum of all
numbers in sheet 1 with the same name in colum A.

If a type =sum(vlookup(...........)
I only get the first number per name from sheet 1.

/Jan


SirSimons Wrote:
gt; Hi
gt;
gt; I have a workbook with 2 sheets.
gt;
gt; In sheet 1 I have 2 colums. Colum A containing names, colum B
gt; containing
gt; numbers.
gt;
gt; On sheet 2 I would like to make a function that gives me the sum of
gt; all
gt; numbers in sheet 1 with the same name in colum A.
gt;
gt; If a type =sum(vlookup(...........)
gt; I only get the first number per name from sheet 1.
gt;
gt; /Jan

ASSUMING that:

1. the range of your data in Sheet 1 is A1:B100;
2. the names entered in Sheet 2 are all in Column A

enter this formula in Cell B1, Sheet2:

=SUMIF(SHEET1!$A$1:$A$100,A1,SHEET1!$B$1:$B$100)

and copy down until your range requirement in Sheet 2 is met.

Hope this is what you are looking for.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=503995Hi

I can use the Sumif commando, but I would also like to get the 95% fraktile
of the numbers...

quot;BenjieLopquot; skrev:

gt;
gt; SirSimons Wrote:
gt; gt; Hi
gt; gt;
gt; gt; I have a workbook with 2 sheets.
gt; gt;
gt; gt; In sheet 1 I have 2 colums. Colum A containing names, colum B
gt; gt; containing
gt; gt; numbers.
gt; gt;
gt; gt; On sheet 2 I would like to make a function that gives me the sum of
gt; gt; all
gt; gt; numbers in sheet 1 with the same name in colum A.
gt; gt;
gt; gt; If a type =sum(vlookup(...........)
gt; gt; I only get the first number per name from sheet 1.
gt; gt;
gt; gt; /Jan
gt;
gt; ASSUMING that:
gt;
gt; 1. the range of your data in Sheet 1 is A1:B100;
gt; 2. the names entered in Sheet 2 are all in Column A
gt;
gt; enter this formula in Cell B1, Sheet2:
gt;
gt; =SUMIF(SHEET1!$A$1:$A$100,A1,SHEET1!$B$1:$B$100)
gt;
gt; and copy down until your range requirement in Sheet 2 is met.
gt;
gt; Hope this is what you are looking for.
gt;
gt; Regards.
gt;
gt;
gt; --
gt; BenjieLop
gt;
gt;
gt; ------------------------------------------------------------------------
gt; BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
gt; View this thread: www.excelforum.com/showthread...hreadid=503995
gt;
gt;