Thread: How can I count the number of repeats in a list of data?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default How can I count the number of repeats in a list of data?
Try:

=SUMPRODUCT(--(A1:A100=1),--(B1:B100=2))

"SouthCarolina" wrote:

I do that and I get a "#VALUE" error. Any suggestions.

"vezerid" wrote:

Then you probably need something like:

=SUMPRODUCT((A1:A100=1)*(B1:B100=2))

HTH
Kostis Vezerides


Reply With QuoteReply With Quote