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

Fikko

Try posting this to a Microsoft Excel group.

--

Ronnie Vernon
Microsoft MVP
Windows Desktop Experience


"fikko" <> wrote in message
news:FA93AE36-1039-441A-980A-...
> 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

"fikko" <> wrote in message
news:FA93AE36-1039-441A-980A-...
> 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.

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

"fikko" <> wrote in message
news:FA93AE36-1039-441A-980A-...
> 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