| 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
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 |
|
#4
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 |
|
#5
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 |
|
#6
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 |
|
#7
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 |
| 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 | |||
Hybrid Mode
