You're welcome. Thanks for the feedback!

Biff

"Pierre" wrote in message
ups.com...

Biff wrote:
Hi!

Try this:

This data in the range A2:C5

12587-A 1 2
12587-A 3 2.8
12587-A 4 8
12587-A 6 65


A10 = 12587-A
B10:S10 = 1,2,3,4,5....18

Formula in B11 copied across:

=IF(SUMPRODUCT(--($A$2:$A$5=$A10),--($B$2:$B$5=B10),$C$2:$C$5)=0,"",SUMPRODUCT(--($A$2:$A$5=$A10),--($B$2:$B$5=B10),$C$2:$C$5))

This assumes that there will be no duplicates. Such as:

12587-A 1 2
12587-A 1 2.8
12587-A 1 8
12587-A 6 65

Biff


Biff, you're a genius. Thank you!

Pierre