=sumproduct(--(secondcolumn="Microsoft"),--(len(trim(fourthcolumn))0),third
column)

--
Regards,
Tom Ogilvy

"amrezzat" wrote in
message ...

you didnt get what i means
i only want to sum the numbers in third column if they only belonged to
one company(suppose company number (microsoft)) and also if the forth
column have a value in it
so in that example
the summation of microsoft is 100+100=200


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile:
http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=485028