Hi All,
I have a file that tracks person counts in multiple building, on an almost daily basis. But i can seem to figure out how to get a count of all people in all buildings as of most recent information provided. -- in the table below, the "should be summed" would be counted to total 24
Date building count should be summed 3/1/2020 a 4 3/1/2020 b 4 3/1/2020 c 4 3/2/2020 a 5 y 3/2/2020 b 5 y 3/2/2020 c 5 3/2/2020 d 5 y 3/3/2020 c 6 y 3/3/2020 e 3 y
Bookmarks