Excel Combining Countif and Vlookup
Table 1 (Input): Name Value Bob 0.5 John 1.2 Bob 0.3 John 0.1 Jane 3 Table 2 (Expected Output): Name >=0 &
Table 1 (input):
| Name | Value |
|---|---|
| Bob | 0.5 |
| John | 1.2 |
| Bob | 0.3 |
| John | 0.1 |
| Jane | 3 |
Table 2 (expected output):
| Name | >=0 & <1 Count |
|---|---|
| Bob | 2 |
| John | 1 |
| Jane | 0 |
I'm looking to count the names in Table2 (column A) every instance in which the name appears in Table1 but only if their value columns in Table1 is between 0 and 1.
I'm assuming I have to combine VLOOKUP with COUNTIFS but I am not sure.. Nothing works..
NOTE: PivotTables are not an option, Table2 column B must have the right formula to count these instances with the two criteria applied. Likely ">="&0 and "<="&1 should be present in the formula.
Thank you for your help!
1 Answer
Just COUNTIFS:
=COUNTIFS(A:A,D2,B:B,">=0",B:B,"<1")
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
