Use this array formula.


=SUM(IF($F$6:$F$91=90,$G$6:$I$91,0))

Commit with Ctrl-Shift-Enter rather than enter after typing in the
formula. It will result in curly brackets around your formula like,

{=SUM(IF($F$2:$F$8=90,$G$2:$I$8,0))}

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=502449