SOLVED
Home

Count.ifs to count number of 'Beds taken'

Randy Brouwer
New Contributor

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$1306;">=1-1-2016")

Column A = admission date

Column E = discharge date

 

So far, so good, this works. 

The problem is I have to analyse this for a whole year and I can't  'drag down' the formula above, since the date won't adjust automatically. So I created a column with the date in it and rewrote the formula to

 

=COUNT.IFS($A$2:$A$1306;"<=J2";$E$2:$E$1306;">=J2")

Column J = the date for number of beds taken

 

Then the result directly turns to "0" instead of the true values I had with the other formula.

 

Does anyone know how I can let the date 'autoadjust' when I drag down, or how I can correctly use a Cell value as a criteria in the second value?

2 Replies
Solution

Hi Randy,

"<=" & J2

and so on

Thank you very much! Made my day, problem solved!! :) 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies