Okay, switching back to Date In C8 copied (copy and paste) to D8:P8
=SUMIFS(tbData[[P2 ]],tbData[gfap],IF($I$2="All","*",$I$2),tbData[Location],$B$2,tbData[Unique patients],1,tbData[ymd_first_service],">="&G$5,tbData[ymd_first_service],"<"&EDATE(G$5,1))
This seems to be counting correctly.
Bookmarks