Thread: count if
View Single Post
  #1   Report Post  
G
 
Posts: n/a
Default count if


Hi ,

What would be the easiest way to calculate the number of entries in in the
following scenario :

B1 : B25 contains dates ( although not all fields will contain data yet )
C1 : C25 contains contact type details i.e. E-mail , phone call ( again not
all will contain data )

I want to show the number of contacts made within the last 4 weeks but omit
one kind (left message).

I am sure there is a simple way but cannot work it out !!

Thanks in advance