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!

[Fotis1991]

In C5 of your first sheet put this. Copy down and across. Same way for the other one.

=COUNTIFS('Daily Discarded and Transfused'!$D$37:$D$600,C$4,'Daily Discarded and Transfused'!$F$37:$F$600,'Daily Received October'!$B5)

[e.isayev]

Daily Recieved order, c5 cell
=COUNTIFS($D$42:$D$903,C$4,$B$42:$B$903,$B5)

[benishiryo]

hi rose4emi, not sure if i got you correctly. for "Daily Received October", try:
=SUMPRODUCT(($B$42:$B$903=$B5)*($D$42:$D$903=C$4))

this is counting Date Received that is in 1 oct & Blood A+. copy down & across

for Daily Discarded and Transfused, try:
=SUMPRODUCT(($E$37:$E$616=$A$5)*($F$37:$F$616=C$4))

this is counting Unit Status "Discarded" & Date Discarded 1 Oct

[rose4emi]

Thanks for all your responses! I'm trying your suggestions atm