View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default Countdiff with more criteria

Hi Bernd,

A pivot table is not an option in this project as the figures are for the
management only, the employees are allowed to consult their own figures but
not the ones of their colleagues.

I know that you have written a lot of very useful functions but as most of
the colleagues are Excel dummies, I prefer to work it out with the standard
Excel functions, if possible.

With kind regards,

JP



"Bernd P" wrote in message
...
Hello JP,

If you do not want to use a Pivot Table select a sufficiently long
range with two columns and array-enter
=Pstat("count",TEXT(C1:C999,"YYYYMM")="200912",B1: B999,A1:A999)

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

Regards,
Bernd