Forum Discussion
Counting chunks within a row
Hi! I have a really simple spreadsheet that has X's and empty cells. I know its super simple to count how many times X's appear, however, I want to return results that count each "chunk" of cells...
Why don't you test it on the sample data you supplied, and then go from there? As I said in my first reply, I simply assumed that the data you posted was in the range A1:AG1. So I suggest that you do likewise, and you'll see that my formula gives you the precise results you asked for. Once you've got it working for your sample data, we can look at adapting/extending it to different ranges. But first things first.
Regards
Regards
Also, I did not specify but no, it is B2-V2. I missed that part of the original message.
