Excel Formula Help with Countif Function

Hello:
I am hoping that this procedure is possible. It would like my life a lot easier. Here is my question.
I would like to add the number of non-blank cells in a select group of cells.
Example: Cells (C8, C11, C14, C17, C20, C23). If there is a value in those particular cells, that I would like to be counted. I have tried =COUNTIF(C8, C11, C14, C17, C20, C23,">=6/1/2019") but that did not work.
I also tried =COUNTIF(C8:C80,">6/1/2019") but that did not give actual numbers.
If I do a range (C8:C23) there are other dates in other cells that I do not want to count. Example in picture.
Total count of yellow cells only. This is only a small sample of the over task.
Excel.jpg
Thank you in advance.

Thank you Sir. I will address a little later today if that is alright. The picture attached was part of a new sample file, but I will attach that sample instead.

BTW... Love it out your neck of the woods. I lived in Kiowa, CO for a bit.
Thank you,
Tom

Originally Posted by alansidman

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Alan, the thread title is compliant with the new rules

1. Title must briefly summarize your request. (A, Z)

The OP has submitted a request for help with an excel formula.

Bearing in mind that TJStephens has only joined the forum today, if you're not happy with the title then, as a moderator, you could always change it (as per forum rule note A) to something that you think is more acceptable.

For dates greater >= the specified criteria, one way would be with a frequency array formula like

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

If you need to use it with dates <= criteria, or between 2 dates then it will need a slight modification.

Hope this helps.

As of this morning, they added more rows of data/information so that it is now not able to be counted by every third row. I am working on a solution in the "range Area" as opposed to static lines.
with the above formula using "Index" it worked on some of the columns but not all as it came up with different values though the format was the same. The date format was also consistent for all the cells in all the columns. Not sure what would have caused a variance like that.
Thank you for the advice Jason.b75. I appreciate it. I am adding a sample spreadsheet.

The way that I set the formula up, it will only work with the pattern that you show in your original post, the MOD() part of it is looking at every third row from row 2 (2,5,8,11 etc). If the pattern changes, then the formula needs to change too.

Something that I overlooked in your screen capture was the entry below the date, if your real data is consistent with your example in that there will be a text / alphanumeric entry directly below the dates of interest, then that can be used as an identifier.

Formula:

Please Login or Register  to view this content.

Note that the first range starts and ends one row lower than the second range.
The criteria of "?*" will ignore numbers (including proper dates) and blank / empty cells. There must be at least one non-numeric charcter in the cell for it to be counted.