Forum Discussion
Solved
Count of people on a ward for a list of dates
Morning everyone I'm using Office/Excel 2010 and have a long list of patients with a date they arrived on a ward and the date the left the ward; what i need is a count of all the people that are on ...
Ian_in_the_NHS , if in A2 is 02 Apr, when 331 and 332 do not meet your condition (date in J is more than A2). I guess it shall be "more or equal to" like
=SUMPRODUCT((A2>=$I$5:$I$537)*(A2<=$J$5:$J$537))
Ian_in_the_NHS , if in A2 is 02 Apr, when 331 and 332 do not meet your condition (date in J is more than A2). I guess it shall be "more or equal to" like
=SUMPRODUCT((A2>=$I$5:$I$537)*(A2<=$J$5:$J$537))
Hi SergeiBaklan
Many thanks for that, it works! It's amazing how much difference two little characters could make!
Brgds
Ian
Hi Ian, glad to help
