Hello,
I have a list in column A containing a lot of number 1, hyphens and blank cells.
In the column D there is a problem how to make formula that will count cells with number 1 between two hyphens (while ignoring blank cells).
I attached xls document for better understanding (in Column D there are a few first results that I'm trying to reach for whole document)
Bookmarks