What I want to do is this; if I have vendor1 who has X number of items but some are inactive I want to count vendor1 but leave out the inactive items from the count.

I know that I can use the formula =countif(range,"vendor1") to count the total of all items from vendor1; however I want to write a formula that will count if vendor1 is the text but there are blanks in another range.

So for instance I have range A2:A61 and the text is vendor1 and then in G2:G61 I have blanks mixed with dates that show when items are inactive.

How do I count vendor1 but not include the inactive items in the count?

Any help would be great. Ive tried various things like =countif(range,IF(ISBLANK(range)),"vendor1") and other experiementation with formulas that probably shouldnt go together and I really am needing to get something that works.

Thanks