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

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

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

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

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

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

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