Currently I use this formula to calculate a total for me: =SUMPRODUCT(--((N9>=Table35[Admit Date])*(N9<=Table35[Discharge Date])))
What I need to do is add a criteria of when Table35[Facility]="MH" to this formula, but can't seem to get the syntax to work correctly.
Any help would be awesome!
Thanks!
Bookmarks