help me on tough sum on conditions issue
heloo if i have 5 columns like these 1 microsoft 100 50 2 sakhr 3 intel 1 microsoft 100 50 1 microsoft 100 40 and i want to sum the third column only if the forth column has a value (for only the numer one company (microsoft) ) so the answer will be 200 not 300 thanks -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=485033 |
help me on tough sum on conditions issue
=SUM (IF((A1:A1001)*(D1:D100<""),C1:C100))
which is an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "amrezzat" wrote in message ... heloo if i have 5 columns like these 1 microsoft 100 50 2 sakhr 3 intel 1 microsoft 100 50 1 microsoft 100 40 and i want to sum the third column only if the forth column has a value (for only the numer one company (microsoft) ) so the answer will be 200 not 300 thanks -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=485033 |
help me on tough sum on conditions issue
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 |
help me on tough sum on conditions issue
=SUMPRODUCT(--(A2:A50="Microsoft"),--(D2:D50<""),C2:C50)
replace Microsoft with a cell where you put the company name or with one of your numbers (1 for Microsoft?) -- Regards, Peo Sjoblom (No private emails please) "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 |
help me on tough sum on conditions issue
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 |
All times are GMT +1. The time now is 05:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com