Hi -

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:
=-COUNT(G43:G999)+COUNTIF(G43:G999,">="&A2)+COUNTIF(G43:G999,"<="&A3)

I have a second column with names of companies which I total as follows:
=COUNTIF(E43:E999,"*ALO*")

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?

Thanks