G Guest Aug 24, 2006 #1 I want to count all the X's in Cells A5:A10 if there is a C in Cells B5:B10. Can someone help? Thanks
I want to count all the X's in Cells A5:A10 if there is a C in Cells B5:B10. Can someone help? Thanks
B Bob Phillips Aug 24, 2006 #2 =SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
S shail Aug 24, 2006 #4 Bob, why do we need "--" between the brackets? I did this formulae as =SUMPRODUCT((A5:A10="X")*(B5:B10="C")) and this too worked fine, but again I don't know why I need to use " * " multiplication here. Please do let me know both the things. thanks Shail
Bob, why do we need "--" between the brackets? I did this formulae as =SUMPRODUCT((A5:A10="X")*(B5:B10="C")) and this too worked fine, but again I don't know why I need to use " * " multiplication here. Please do let me know both the things. thanks Shail
B Bernard Liengme Aug 24, 2006 #5 Both will work. For explanation of -- see http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes
Both will work. For explanation of -- see http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes
S shail Aug 24, 2006 #6 Thanks Bernard, I understand. Shail Bernard said: Both will work. For explanation of -- see http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes Click to expand...
Thanks Bernard, I understand. Shail Bernard said: Both will work. For explanation of -- see http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes Click to expand...
B Bob Phillips Aug 24, 2006 #7 See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
