Thread: SumIF or CountIF
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default SumIF or CountIF
Hello,

Select a range of 4 rows (or more) and 3 columns and array-enter:
=Pfreq(B2:B99,A2:A99)

Pfreq you can get he
http://sulprobil.com/html/pfreq.html

Regards,
Bernd
Reply With QuoteReply With Quote