Using Excel 2010, attempting to use COUNTIF with Date qualifier & multiple conditions

Hello! I am attempting to do that which could very easily be done with a pivot table, but instead I have manually set up a chart instead for graphing that would take a lot of work to redo. I am attempting to set up the counting of instances of various absences based on the date and several different names of time off.

Attached is a makeshift spreadsheet of what I'm working with

I would like the formula to reference the range B:B to see if it matches cell G1 (the date) and if it does, count all instances of specific time - Sick, Personal, Vacation, Unpaid - and provide a total count for each type in column A. If it does not match the date, do not count it. I'd like to just be able to paste data into the section with the date and absenteeism data and have the chart update / count automatically as if it were a pivot table into the correct date column.

I have tried IF statement - =IF(B:B=F1,COUNTIF(A:A,"Sick")*COUNTIF(A:A,"Personal")*COUNTIF(A:A,"Unpaid"))
And COUNTIF - =COUNTIF(A:A,"Sick")*COUNTIF(A:A,"Personal")*COUNTIF(A:A,"Unpaid")
But these didn't work.

Any help would be greatly appreciated and if I figure out a solution I will post it here -

Thank you!