SumIf will not work in this case
 

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

SUMIF is a wrong choice. If you use XL-2007 then use SUMIFS(), prior to
XL-2007 use SUMPRODUCT()

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=0.5),C1:C100)

You can't not use a whole column unless you use XL-2007



"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

If you have more than one criteria then you can't use SUMIF - use
SUMPRODUCT instead. If you are using XL2003 or earlier then you can't
use full-column references with SP, and it is better to keep the
ranges just as large as required to cover your data. Something like
this:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=50%),C1:C100)

The -- converts True and False to 1 and 0 respectively for each
element. Another way of writing it is:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%),C1:C1 00)

or even:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

where * is equivalent to AND.

Hope this helps.

Pete

On Nov 11, 1:19*am, Need help with sumif
wrote:
How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C

Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B10050%),(C1:C100))

"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

With two or more criteria, always think SUMPRODUCT():

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

--
Gary''s Student - gsnu200812


"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

Well

let me rephrase my question maybe I explained wrong

I'm trying to find only "Apple" in column A also find only it's sale is
more than 50% in column B then sum C column that's in a same row

"Teethless mama" wrote:

SUMIF is a wrong choice. If you use XL-2007 then use SUMIFS(), prior to
XL-2007 use SUMPRODUCT()

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=0.5),C1:C100)

You can't not use a whole column unless you use XL-2007



"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

Thanks

"Sheeloo" wrote:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B10050%),(C1:C100))

"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

Thank you it works perfect

"Need help with sumif" wrote:

Well

let me rephrase my question maybe I explained wrong

I'm trying to find only "Apple" in column A also find only it's sale is
more than 50% in column B then sum C column that's in a same row

"Teethless mama" wrote:

SUMIF is a wrong choice. If you use XL-2007 then use SUMIFS(), prior to
XL-2007 use SUMPRODUCT()

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=0.5),C1:C100)

You can't not use a whole column unless you use XL-2007



"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

Thank you very much

"Gary''s Student" wrote:

With two or more criteria, always think SUMPRODUCT():

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

--
Gary''s Student - gsnu200812


"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

Thank you for the details

"Pete_UK" wrote:

If you have more than one criteria then you can't use SUMIF - use
SUMPRODUCT instead. If you are using XL2003 or earlier then you can't
use full-column references with SP, and it is better to keep the
ranges just as large as required to cover your data. Something like
this:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=50%),C1:C100)

The -- converts True and False to 1 and 0 respectively for each
element. Another way of writing it is:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%),C1:C1 00)

or even:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

where * is equivalent to AND.

Hope this helps.

Pete

On Nov 11, 1:19 am, Need help with sumif
wrote:
How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C

Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

Hi,

In 2007 you can use SUMIFS for this example it would be

=SUMIFS(C1:C100,A1:A100,"Apple",B1:B100,"=50%")

--
Thanks,
Shane Devenshire


"Pete_UK" wrote:

If you have more than one criteria then you can't use SUMIF - use
SUMPRODUCT instead. If you are using XL2003 or earlier then you can't
use full-column references with SP, and it is better to keep the
ranges just as large as required to cover your data. Something like
this:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=50%),C1:C100)

The -- converts True and False to 1 and 0 respectively for each
element. Another way of writing it is:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%),C1:C1 00)

or even:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

where * is equivalent to AND.

Hope this helps.

Pete

On Nov 11, 1:19 am, Need help with sumif
wrote:
How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C

Let me know if there is other solution other then SUMIF also

SumIf will not work in this case
 

You're welcome.

Pete

On Nov 11, 1:55*am, Need help with sumif
wrote:
Thank you for the details



"Pete_UK" wrote:
If you have more than one criteria then you can't use SUMIF - use
SUMPRODUCT instead. If you are using XL2003 or earlier then you can't
use full-column references with SP, and it is better to keep the
ranges just as large as required to cover your data. Something like
this:

=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B100=50%),C1:C100)

The -- converts True and False to 1 and 0 respectively for each
element. Another way of writing it is:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%),C1:C1 00)

or even:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

where * is equivalent to AND.

Hope this helps.

Pete

On Nov 11, 1:19 am, Need help with sumif
wrote:
How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C

Let me know if there is other solution other then SUMIF also- Hide quoted text -

- Show quoted text -