Team A B C D E F G H I J K
One 5 6 5 6 5 7 9 5
Two 5 6 5 6 6 6 6
Three 7 7 7 7 7 7 7 7 7 7

> Team A B C D E F G H I J K
> One 5 6 5 6 5 7 9 5
> Two 5 6 5 6 6 6
> 6
> Three 7 7 7 7 7 7 7 7 7 7

Your question is" "How do I count the last six non black cells?"

I am not trying to be flippant or anything, but won't that number be 6
(possibly, per row)?

I think you might need to provide some more detail about what you are trying
to do.

Rick

i was guessing they meant sum, but i'm not sure.

--


Gary


"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>> Team A B C D E F G H I J K
>> One 5 6 5 6 5 7 9 5
>> Two 5 6 5 6 6 6 6
>> Three 7 7 7 7 7 7 7 7 7 7
>
> Your question is" "How do I count the last six non black cells?"
>
> I am not trying to be flippant or anything, but won't that number be 6
> (possibly, per row)?
>
> I think you might need to provide some more detail about what you are trying
> to do.
>
> Rick

You mean sum don't you?

=SUM(N(OFFSET(A2,0,LARGE(IF(B2:L2<>"",COLUMN(B1:L1)),{1,2,3,4,5,6})-1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kleinerman" <(E-Mail Removed)> wrote in message
news:FD01310D-C105-4C9F-91C0-(E-Mail Removed)...
> Team A B C D E F G H I J K
> One 5 6 5 6 5 7 9 5
> Two 5 6 5 6 6 6
> 6
> Three 7 7 7 7 7 7 7 7 7 7

1, 2, 3, 4, 5, 6

:0 (sorry, it's quitin' time on a Friday!)

We need more info to answer.


"Gary Keramidas" wrote:

> i was guessing they meant sum, but i'm not sure.
>
> --
>
>
> Gary
>
>
> "Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> >> Team A B C D E F G H I J K
> >> One 5 6 5 6 5 7 9 5
> >> Two 5 6 5 6 6 6 6
> >> Three 7 7 7 7 7 7 7 7 7 7
> >
> > Your question is" "How do I count the last six non black cells?"
> >
> > I am not trying to be flippant or anything, but won't that number be 6
> > (possibly, per row)?
> >
> > I think you might need to provide some more detail about what you are trying
> > to do.
> >
> > Rick
>
>
>

Thank you exactly what I needed. Did not know about the Ctrl-Shift-Enter part.

"Bob Phillips" wrote:

> You mean sum don't you?
>
> =SUM(N(OFFSET(A2,0,LARGE(IF(B2:L2<>"",COLUMN(B1:L1)),{1,2,3,4,5,6})-1)))
>
> which is an array formula, it should be committed with Ctrl-Shift-Enter, not
> just Enter.
> Excel will automatically enclose the formula in braces (curly brackets), do
> not try to do this manually.
> When editing the formula, it must again be array-entered.
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Kleinerman" <(E-Mail Removed)> wrote in message
> news:FD01310D-C105-4C9F-91C0-(E-Mail Removed)...
> > Team A B C D E F G H I J K
> > One 5 6 5 6 5 7 9 5
> > Two 5 6 5 6 6 6
> > 6
> > Three 7 7 7 7 7 7 7 7 7 7
>
>
>