Good afternoon Trafficbroker

You have two options here :

1. Using SUMIF for each of your ref values eg
=SUMIF(B5:B14,4,C5:C14).

2. A simple pivot table would be easy to create and maintain, but the
links in a pivot table are not as dynamic as an excel formula would be.
You would have to update it manually.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=483964