View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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