There's probably something a little more elegant, but this should do the
job:
In O3 put the formula =IF(and(D3="C",E3=3),N3,0)
In T3 put the formula =IF(AND(D3="C",E3=2),N3,0)
and so on
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=391381