View Single Post
  #3   Report Post  
joes
 
Posts: n/a
Default

Many thanks it works... great.

What I wonder is only why is it working with the "SUMPRODUCT" and not
with the "COUNTIF", does the "SUMPRODUCT" not do any type conversations
or is this beacuse this function does it calculate differently. If
someone could delight me what the calculation steps are above would
help. What means the "--" multiplication with itself?

regards
Mark