SOLVED

CountIf Formula help

Copper Contributor

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.

2 Replies

@MKScott 

Perhaps SUMIFS()

best response confirmed by MKScott (Copper Contributor)
Solution
Thanks. I think this worked:
=SUMIF($B$2:$B$13000,"FL",$D$2:$D$13000)
=SUMIF($B$2:$B$13000,"AL",$D$2:$D$13000)
=SUMIF($B$2:$B$13000,"GA",$D$2:$D$13000)
1 best response

Accepted Solutions
best response confirmed by MKScott (Copper Contributor)
Solution
Thanks. I think this worked:
=SUMIF($B$2:$B$13000,"FL",$D$2:$D$13000)
=SUMIF($B$2:$B$13000,"AL",$D$2:$D$13000)
=SUMIF($B$2:$B$13000,"GA",$D$2:$D$13000)

View solution in original post