Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count function
see me most recent post in this thread - that was a mistake because I wasn't
sure exactly what you wanted. anyway, for your adjusted ranges it would be: =SUMPRODUCT((A20:A42-A19:A410)*(A19:A41<"")*(A20:A42<"")) Regards, Tom Ogilvy "Omi" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Function | Excel Worksheet Functions | |||
Count and Sum function | Excel Worksheet Functions | |||
Count function | Excel Discussion (Misc queries) | |||
COUNT IF FUNCTION | Excel Worksheet Functions | |||
Count Function | Excel Worksheet Functions |