Combining a Date Range COUNTIF and a general COUNTIF
I have a column in my chart that has a set of dates and to determine if a date falls within a range located in A2 and A3 I use the following:
I have a second column with names of companies which I total as follows:
Is there a way for me to combine both of these so that I can know how many times the ALO company listed in column E appears within a specified date range from column G?
Re: Combining a Date Range COUNTIF and a general COUNTIF
in Excel 2007 and later, you can use Countifs() instead of Countif.
In Excel 2003 and earlier, Sumproduct() will be able to do what you need
Sumproduct does not support wildcards in comparisons, hence the loop through Search and Iserror.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1