Is there a way to do a double Count If formula?
i did the first 3 manually in B2, B3, B4
I filtered the sites by state and then manually selected the sites in A2, A3, A4, but what I need to be able to do is for the countif to check how many sites are in each state
So for OH I have:
8 Sites of DOUBLE PARK
35 Sites of TRIPLE PARK
5 Sites of SINGLE PARK
Can i have the formula count the number of each of those sites per State without having to sort them by state first and manually selecting?
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Type | Number of Sites | State | ||
2 | Double Park | 8 | OH | ||
3 | Triple Park | 35 | OH | ||
4 | Single Park | 5 | OH | ||
5 | Double Park | 44 | PA | ||
6 | Triple Park | 36 | PA | ||
7 | Single Park | 2 | PA | ||
8 | Double Park | 6 | FL | ||
9 | Triple Park | 22 | FL | ||
10 | Single Park | 1 | FL | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | =COUNTIF(Sheet3!A2:A9,A2) | |
B3 | =COUNTIF(Sheet3!A10:A49,A3) | |
B4 | =COUNTIF(Sheet3!A45:A49,A4) |
i did the first 3 manually in B2, B3, B4
I filtered the sites by state and then manually selected the sites in A2, A3, A4, but what I need to be able to do is for the countif to check how many sites are in each state
So for OH I have:
8 Sites of DOUBLE PARK
35 Sites of TRIPLE PARK
5 Sites of SINGLE PARK
Can i have the formula count the number of each of those sites per State without having to sort them by state first and manually selecting?