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
|