Formula to count the cells that are not "Blank" based on different cases

Hi All,

I am working on finding the count of total number of cells that are not empty(irrespective of the content in column 'Blank') based on 3 Cases.

Test.JPG

Case 1: For condition "Test 2" occurring today only i.e 17-Jul-2018. Check if the column titled "Blank" has cells with any value in it? If cells have a Value, get the total count of cells.

Case 2: For condition "Test 2" occurring today only i.e 17-Jul-2018. Check if the column titled "Blank" has cells with any value, corresponding to status "Open"? If cells have a Value, get the total count of cells.

Case 3: For all status that are "Open", For condition "Test 2"; Check if the column titled "Blank" has cells with any value? If cells have a Value, get the total count of cells. (This case is irrespective of date)

Thank You in Advance

Case 1

Formula:

Please Login or Register  to view this content.

Case 2

Formula:

Please Login or Register  to view this content.

Case 3

Formula:

Please Login or Register  to view this content.

BSB

Many thanks @BadlySpelledBuoy and @PaulM100. It was very helpful