Count number of times a specific value is found for a given date

Hi,

Similar to a post of mine earlier, however, this is slightly different. What I am looking to do is count the number of times a specific value is found for a given date.

Unless you guys come up with a totally better method, for now as shown in the below screenshot (full spreadsheet also attached). I created a separate table on the right starting from column G, where I count the number of times each event (Major, Minor or blank) occurs for a given date, so 11/11/2019 as shown within cell G2. I have manually entered for now the first 4 rows on the right table to show how the results should be populated based on the table on the left. I want to enter formulas within cells H2 to J13 (providing this is the method to do so haha!) to count the total for me.


Capture2.PNG

- Is there a certain function(s) that works best?
- Is there a neater way to go about this then the table I created?
- Also for the blank cells, is whatever formula you guys suggest going to be able to pick the blank cells up and count it to the total?

I would appreciate if someone could help me please

Use these formulae in the cells stated:

H2: =COUNTIF($B2:$E2,H$1)

I2: =COUNTIF($B2:$E2,I$1) … i.e. copy the formula from H2 into I2

J2: =COUNTIF($B2:$E2,"")

Then copy all three formulae down to row 13.

Hope this helps.

Pete

If it's alright I'd like to resolve an issue similar to this one that I have?
Attachment 657203

I would like to get the quantity of cells that contain the number 6 (in this image i believe there's only 2). What's the simplest formula?

Thanks!