Thread: Counting with Conditions but Only Once
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Counting with Conditions but Only Once
Hello,

Array-enter
=COUNT(Pstat("Count",(L2:L3000="M")*(D2:D3000=8)*( E2:E3000<=12)*
(E2:E3000=6),B2:B3000))

Pstat you can get he
http://sulprobil.com/html/pstat.html

Regards,
Bernd
Reply With QuoteReply With Quote