Vista Tutorial - Excel function

02-17-2008

Is there a function which provides the sum of the values in column B that
correspond to a specified value in column A.
eg

A B
1 2
1 3
2 0
3 0
4 5
4 5
4 5

1 would return 5, 2 or 3 would return 0 and 4 would return 15

ta

02-17-2008

Fikko

Try posting this to a Microsoft Excel group.

--

Ronnie Vernon
Microsoft MVP
Windows Desktop Experience

"fikko" <fikko@xxxxxx> wrote in message
news:FA93AE36-1039-441A-980A-9BF4988915E4@xxxxxx

Quote:

> Is there a function which provides the sum of the values in column B that
> correspond to a specified value in column A.
> eg
>
> A B
> 1 2
> 1 3
> 2 0
> 3 0
> 4 5
> 4 5
> 4 5
>
> 1 would return 5, 2 or 3 would return 0 and 4 would return 15
>
> ta

02-17-2008

"fikko" <fikko@xxxxxx> wrote in message
news:FA93AE36-1039-441A-980A-9BF4988915E4@xxxxxx

Quote:

> Is there a function which provides the sum of the values in column B that
> correspond to a specified value in column A.
> eg
>
> A B
> 1 2
> 1 3
> 2 0
> 3 0
> 4 5
> 4 5
> 4 5
>
> 1 would return 5, 2 or 3 would return 0 and 4 would return 15
>
> ta

I believe "Lookup" is what you are looking for. But you need to ask this
question in the Excel newsgroup.
BobF.

02-17-2008

Ask your question in microsoft.public.excel.misc.

"fikko" <fikko@xxxxxx> wrote in message
news:FA93AE36-1039-441A-980A-9BF4988915E4@xxxxxx

Quote:

> Is there a function which provides the sum of the values in column B that
> correspond to a specified value in column A.
> eg
>
> A B
> 1 2
> 1 3
> 2 0
> 3 0
> 4 5
> 4 5
> 4 5
>
> 1 would return 5, 2 or 3 would return 0 and 4 would return 15
>
> ta

02-17-2008	#1 (permalink)
fikko Guest n/a posts	Excel function Is there a function which provides the sum of the values in column B that correspond to a specified value in column A. eg A B 1 2 1 3 2 0 3 0 4 5 4 5 4 5 1 would return 5, 2 or 3 would return 0 and 4 would return 15 ta
My System Specs

02-17-2008	#2 (permalink)
Ronnie Vernon MVP Guest n/a posts	Re: Excel function Fikko Try posting this to a Microsoft Excel group. -- Ronnie Vernon Microsoft MVP Windows Desktop Experience "fikko" <fikko@xxxxxx> wrote in message news:FA93AE36-1039-441A-980A-9BF4988915E4@xxxxxx Quote: > Is there a function which provides the sum of the values in column B that > correspond to a specified value in column A. > eg > > A B > 1 2 > 1 3 > 2 0 > 3 0 > 4 5 > 4 5 > 4 5 > > 1 would return 5, 2 or 3 would return 0 and 4 would return 15 > > ta
My System Specs

02-17-2008	#3 (permalink)
Bob F. Guest n/a posts	Re: Excel function "fikko" <fikko@xxxxxx> wrote in message news:FA93AE36-1039-441A-980A-9BF4988915E4@xxxxxx Quote: > Is there a function which provides the sum of the values in column B that > correspond to a specified value in column A. > eg > > A B > 1 2 > 1 3 > 2 0 > 3 0 > 4 5 > 4 5 > 4 5 > > 1 would return 5, 2 or 3 would return 0 and 4 would return 15 > > ta I believe "Lookup" is what you are looking for. But you need to ask this question in the Excel newsgroup. BobF.
My System Specs

02-17-2008	#4 (permalink)
Bob Guest n/a posts	Re: Excel function Ask your question in microsoft.public.excel.misc. "fikko" <fikko@xxxxxx> wrote in message news:FA93AE36-1039-441A-980A-9BF4988915E4@xxxxxx Quote: > Is there a function which provides the sum of the values in column B that > correspond to a specified value in column A. > eg > > A B > 1 2 > 1 3 > 2 0 > 3 0 > 4 5 > 4 5 > 4 5 > > 1 would return 5, 2 or 3 would return 0 and 4 would return 15 > > ta
My System Specs

Similar Threads
Thread	Forum
Re: Calling excel function	VB Script
VBScript to search LDAP from Excel function?	VB Script
Is there a write-multi-cell-at-once function in VBS for Excel?	VB Script
Excel IF Function Help	Vista General
VBA Function not recognized in Excel	Vista General