COUNTIF with multiple criteria on several columns (different column heading)

[rose4emi]

Hi,

What formula can I use if I want to get a daily count of the data based on criteria across different columns?

I want it to automatically count the data instead of doing it manually, for example:

Daily Received Sheet - C5 will show the total number of units received on october 1st group A+
Daily discarded & transfused - C5 will show the total number of units discarded on Oct 1st with reason "Expired"

Please help how to write the formula correctly. See attachment

Thanks!