View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Omi Omi is offline
external usenet poster
 
Posts: 1
Default Count function

Tom,

First of all tahnks for the help

I know I am doing something stupid, but please help me out.

I entered the formula (Like I though U suggested) and I
get 22. Please tell me what I am doing wrong

=SUMPRODUCT((ABS(A19:A41-A20:A42)0)*(A19:A41<"")*
(A20:A42<""))

58.63
58.27
58.66
59.21
59.73
59.57
59.43
60.38
60.64
60.37
61.14
61.63
61.46
60.75
60.85
59.93
59.35
59.7
59.05
59.2
58.88
58.34
59.74



Thanks Again