Hi,

Think this works. This assumes

1). Your sheet called Data - Change as required
2). A2 = Item A. Make sure $ in front of A2
3). B2 = Serial Number again make sure $ in front of B2
4). C1 = No of calls one. Change $C$1 to $D$1 etc for 2 calls etc.
Again use absolute values

=SUMPRODUCT(--(Data!$A$2:$A$100=$A2)*(--(Data!$B$2:$B$100=$B2)*(--(Data!$C$2:$C$100=$C$1))))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569168