mikeconstantino
New Member
- Joined
- Nov 26, 2005
- Messages
- 20
Hello, I need some assistance with a countif, or a better formula to use. I want to count all the items in column D that match "Customer" only if the range in column I matches "New England". Any assistance would be appreciated.
COUNTIF(I2:I201, "*"&"New England"&"*"),(D2:D201, "*"&"Customer"&"*"))
COUNTIF(I2:I201, "*"&"New England"&"*"),(D2:D201, "*"&"Customer"&"*"))