in A3 put if(a2="x",a1,0) then copy across whole row, then a sum of that
whole row will give you the required total.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=534481