I think I did, but I omitted an = in the formula
=SUM (IF((A1:A100=1)*(D1:D100<""),C1:C100))
array as before.
But I get 300 not 200, I cannot see your logic for 200.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"amrezzat" wrote in
message ...
you didnt get what i meant
i only want to sum the numbers in third column if they only belonged to
one company(suppose company number 1 (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=485033