thanks ron ure the man, the top one works, havent tried the 1 below it.

i cant thank u enough.

any chance of talking me through that formulae

=SUMIF($A$1:$A$40,5014,$L$1:$L$40)-SUMIF($A$1:$A$40,5014,$M$1:$M$40)


--
stevenmorrison
------------------------------------------------------------------------
stevenmorrison's Profile: http://www.excelforum.com/member.php...o&userid=26188
View this thread: http://www.excelforum.com/showthread...hreadid=394944