I need help putting together a formula that will do the following:
1. Search for company name "ABC" in column A, then
2. Search for product category "Books" in column B, (there a 6 different product categories that I will be searching for), then
3. Search for product distribution type "truck" in column C, then
4. If the above criteria are met then, count the "alphanumeric codes" in column D
<tbody>
</tbody>
I hope the information above is sufficient, I am creating a reporting sheet to pull data from this detailed sheet with thousands of records.
Please assist soonest; thanks.
1. Search for company name "ABC" in column A, then
2. Search for product category "Books" in column B, (there a 6 different product categories that I will be searching for), then
3. Search for product distribution type "truck" in column C, then
4. If the above criteria are met then, count the "alphanumeric codes" in column D
Company Name | Category | Distribution Type | Codes | ||
Bookran | Book | Truck |
<colgroup><col></colgroup><tbody> </tbody> | ||
Telstar | Book | Cart |
<tbody> </tbody> | ||
Major | Pen | Gate | CH3117672 | ||
Bookran | Book | Truck | CS6540201 | ||
Major | Pen | Gate | TN9358217 |
<tbody>
</tbody>
I hope the information above is sufficient, I am creating a reporting sheet to pull data from this detailed sheet with thousands of records.
Please assist soonest; thanks.