Hi michaelas,

try SumIf

e.g.

=SumIf(E1:E100,"No Work",D1:D100)

Obviously, amend the ranges (E1 to E100 and D1 to D100) to suit your
circumstances.

Art


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=398484