Collect Function with Multiple Criteria

Loucas Tsiartas

I have the following collect function that works fine when I only have one criterion (the answer is 6) but, when I add the additional criterion to evaluate the Date I get an answer of 1 instead of the 6 I was expecting. Any help would be appreciated.

Leibel S

@Loucas Tsiartas

This seems to be because the size of the Date Range (1 column) is different then the size of the range being collected (3 columns).

You may need to count each column separately (A separate COLLECT for Column4 another for Column5 and another for Column6).

Loucas Tsiartas

Thank you Leibel, that works. Would you know how much would be the impact to performance if I were to have three Collect functions vs one? My sheet is already slow and don't want to affect performance more.

Leibel S

No idea...