How do I count the last six non blank cells?
 

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

How do I count the last six non blank cells?
 

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

How do I count the last six non blank cells?
 

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

--


Gary


"Rick Rothstein (MVP - VB)" wrote in message
...
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

How do I count the last six non blank cells?
 

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" wrote in message
...
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

How do I count the last six non blank cells?
 

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)" wrote in message
...
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

How do I count the last six non blank cells?
 

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" wrote in message
...
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