help me on condition issues

[amrezzat]

heloo
if i have 5 columns like these

1 microsoft 100 50
2 sakhr
3 intel
1 microsoft 100 50
1 microsoft 100 (this is blank cell) 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

[Leith Ross]

Hello amrezzat,

Lets say you data occupies cells A1:D5. You can use the SUMIF worksheet function to sum the cells based on your criteria.

Example of SUMIF:
SUMIF(Test Range, Criteria, Sum Range)

In this case you place the following formula in the cell of your choice...
=SUMIF(D4:D5, ">0", C4:C5)

Sincerely,
Leith Ross

[amrezzat]

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

[Kleev]

I believe this will work for you:
=SUMPRODUCT(--($A$1:$A$5=1),--($D$1:$D$5<>""),($C$1:$C$5))

"amrezzat" wrote:

>
> 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=485028
>
>

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"amrezzat" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>