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!
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)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Daily Recieved order, c5 cell
=COUNTIFS($D$42:$D$903,C$4,$B$42:$B$903,$B5)
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
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks for all your responses! I'm trying your suggestions atm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks