I have 2 columns on Sheet 2
In column 1 it says Mon all the way down to A10
Then Tues for a few more cells below, then Weds for a few cells and so on.
The list is sorted in order
To the right in Column B some cells have numbers in them and some are blank
On Sheet 1 I want a summary, so it would say:
"Mon" in one cell
And to the right of Mon a count of how many cells next to Mon in Column B (Sheet 2) that have something in them.
How do I do it?
Tried a combination of AND, COUNTIF...
In column 1 it says Mon all the way down to A10
Then Tues for a few more cells below, then Weds for a few cells and so on.
The list is sorted in order
To the right in Column B some cells have numbers in them and some are blank
On Sheet 1 I want a summary, so it would say:
"Mon" in one cell
And to the right of Mon a count of how many cells next to Mon in Column B (Sheet 2) that have something in them.
How do I do it?
Tried a combination of AND, COUNTIF...
