Prev: MS excell 2007 Data verification list
Next: New to VLOOKUP ...merge addresses?
From: JLatham on 4 Apr 2010 18:35
Thanks. I missed that. I didn't think of using sumproduct in the way you
did, and had even tried an array first, but that was a total bust.
Looks like it comes down to which ever formula he prefers or feels more
comfortable with.

"Rick Rothstein" wrote:

> Just pointing out that you wrote the wrong range in your formulas.... you
> wrote A1:I1 instead of A1:J1.
>
> --
> Rick (MVP - Excel)
>
>
>
> "JLatham" <JLatham(a)discussions.microsoft.com> wrote in message
> news:71DB05E5-F74B-456D-A63A-27C0514E2182(a)microsoft.com...
> > =(SUM(A1:I1)-COUNT(A1:I1))*5
> > will also give the same result of 60 and it's a simpler formula, so faster
> > to execute.
> >
> > "nordiyu" wrote:
> >
> >> Sir,
> >> How to count total point for cell A1 to J1:
> >> A B C D E F G I J
> >> 1 4 1 4 3 2 1 1 2 3
> >>
> >> if, 1=0 point, 1=5 point, 2=10 point, 4=15 point
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: MS excell 2007 Data verification list
Next: New to VLOOKUP ...merge addresses?