The example showed numerical values in D3, H3 and I3 but what if one or more
of the values is text that can't be interpreted as a number value?



"daddylonglegs"
wrote in message
news:daddylonglegs.24xyuo_1142813401.0826@excelfor um-nospam.com...

If only one of the cells can have a value just sum them

=IF(A3="HR",SUM(D3,H3:I3),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524100