sumproduct

[Bryan De-Lara]

Hi all,
I have a workbook that I use sumproduct in. But this only counts numeric's.
How can I count (L). If I try to use sumproduct obviously it reports 0.
I need to count from B2 TO B556 in a column. Any help would be appreciated.
Thanks.

 

[John C]

You can still use SUMPRODUCT
=SUMPRODUCT(--(B2:B556="L"))
or you could use a COUNTIF function
=COUNTIF(B2:B556,"L")
If these don't work for you, post your formula, and I, or someone else, can
help

 

[Bernard Liengme]

=SUMPRODUCT(--(A1:A100="L"), --(B1:B100="cats))
this will count how may row have the letter L in A and word cats in B
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Bryan De-Lara]

I feel so stupid now, I tried using it and I couldn't get it to work. I
pasted yours and it works a treat.
Thank you John for such a quick turnaround.
No doubt I will have another question later that has baffled me for the past
year.

Bryan.

 

[John C]

Thanks for the feedback, and don't forget to mark the question answered

 

[Bryan De-Lara]

Silly question, how do I mark it answered?
Bryan

Thanks for the feedback, and don't forget to mark the question answered

 

[John C]

It depends on how you access the help group. Some give stars, some give
little yes boxes below, and some????? who knows
Either way, glad to have helped.

 

[Bryan De-Lara]

I use windows mail, and not given any of those options, so sorry but my
question was answered.