View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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