Forum Discussion

Randy Brouwer's avatar
Randy Brouwer
Copper Contributor
Nov 03, 2017
Solved

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...
  • SergeiBaklan's avatar
    Nov 03, 2017

    Hi Randy,

    "<=" & J2

    and so on

Resources