#### B5rocksass

##### Board Regular
Hello, I have a table with multiple pieces of data (changed for data security). I need to look in the table and look down one column to find specific text, then look to the next column to see if that text matches a criteria, and return the total number of values that match that criteria. So, in the example I've shown below, the final table should show Abby with a quantity of 2, and Lenox of 3. The actual document has hundreds of rows. Please help!

#### B5rocksass

##### Board Regular
James, I tried to add that to the end of the existing formula and it came back with a value of zero.

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### JamesCanale

##### Active Member
...,B\$3:B\$10,"<="&workday(today(),-2)

#### JamesCanale

##### Active Member
=COUNTIFS(C\$3:C\$10,C13,D\$3:D\$10,"N",B\$3:B\$10,"<="&workday(today(),-2))

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=COUNTIFS(C\$3:C\$10,C13,D\$3:D\$10,"N",B\$3:B\$10,">"&WORKDAY(TODAY(),-2))``

Replies
3
Views
152
Replies
13
Views
296
Replies
5
Views
85
Replies
1
Views
145
Replies
20
Views
732

1,141,070
Messages
5,704,112
Members
421,327
Latest member
Msh

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back