Jul 22 2021 10:35 AM
I have CITY, STATE, ADDRESS and TOTAL STORE VISITS.
I know how to COUNTIF for the STATE (=COUNTIF($B$2:$B$13000,"FL")
But, how do I calculate how many visits each state receives? For example: Florida had a total of 815 store visits. Those 815 store visits resulted in 7561 total visits.
Jul 22 2021 10:46 AM
SolutionJul 22 2021 10:46 AM
Solution