Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
=SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C"))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kmason" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
=SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C"))
"kmason" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
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 Phillips wrote: =SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kmason" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
Both will work. For explanation of -- see
http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shail" wrote in message ups.com... 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 Phillips wrote: =SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kmason" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
Thanks Bernard, I understand.
Shail Bernard Liengme wrote: Both will work. For explanation of -- see http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "shail" wrote in message ups.com... 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 Phillips wrote: =SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kmason" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells that meet Criteria
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) "shail" wrote in message ups.com... 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 Phillips wrote: =SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kmason" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
Counting cells that meet 2 differnet criteria | Excel Worksheet Functions | |||
count cells using multiple criteria | Excel Discussion (Misc queries) | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |