How do I count the last six non blank cells?

[Guest]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Gary Keramidas]

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

 

[Bob Phillips]

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)

 

[Guest]

1, 2, 3, 4, 5, 6

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

We need more info to answer.

 

[Guest]

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