It looks like in order to use COUNTIFS, each range must be the same size. Is this true? Are there other rules associated with COUNTIFS? Will any other function work better?
Here's a condensed version of the sheet I'm building. The first two criteria is to get a date range. The last criteria is number of occurrences of a name. It works when applied to the HQ column only. The problem is when getting number of occurrences for multiple franchises.
# of HQ purchases, works: =COUNTIFS(F:F,">="&L8,F:F,"<="&L9,G:G,$L7)
# of franchise purchases, broken: =COUNTIFS(F:F,">="&L8,F:F,"<="&L9,H:I,$L7)
Here's a condensed version of the sheet I'm building. The first two criteria is to get a date range. The last criteria is number of occurrences of a name. It works when applied to the HQ column only. The problem is when getting number of occurrences for multiple franchises.
# of HQ purchases, works: =COUNTIFS(F:F,">="&L8,F:F,"<="&L9,G:G,$L7)
# of franchise purchases, broken: =COUNTIFS(F:F,">="&L8,F:F,"<="&L9,H:I,$L7)