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