I work with spreadsheets to manage various things and currently I am working on a sheet that manages items from multiple vendors. One of the most important parts of this sheet is counting these items from the vendors.
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
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