Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Formula for multiple conditions | Excel Discussion (Misc queries) | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |