Forum Discussion
Randy Brouwer
Nov 03, 2017Copper Contributor
Count.ifs to count number of 'Beds taken'
In order to count 'the numer of beds taken per day', based on arrival date and discharge date of the patient, I constructed this Count.ifs formula: =COUNT.IFS($A$2:$A$1306;"<=1-1-2016";$E$2:$E$13...
- Nov 03, 2017
Hi Randy,
"<=" & J2
and so on
SergeiBaklan
Nov 03, 2017Diamond Contributor
Hi Randy,
"<=" & J2
and so on
- Randy BrouwerNov 03, 2017Copper Contributor
Thank you very much! Made my day, problem solved!! :)