Thread: How can I count the number of repeats in a list of data?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
SouthCarolina
 
Posts: n/a
Default How can I count the number of repeats in a list of data?
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