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