title: Countifs does not work when a range with multiple column is selected
body: <p>I need a count if function that counts me the cells that meet a certain criteria. This should be done with countifs. The formula is the following:
  <code>=COUNTIFS(Orders!D:D;"*Ecolab*";Orders!B:B;"&gt;=01/01/2019";Orders!U:U;"&gt;=36";Orders!K:Q;"&gt;=1")</code>This formula returns me an value type error.</p>
  
  <p>This formula works well until I introduce the last condition <code>orders!K:Q;"&gt;=1"</code>
  I would like a formula that counts if the word Ecolab is present in the cell; if the date is after or equal 01/01/2019; if the column U has more or equal than the number 36 and if there is at least a "1" in the cells in the row from column K to column Q. I could do this by easily replicating the countifs several times, (i.e <code>=COUNTIFS(Orders!D:D;"*Ecolab*";Orders!B:B;"&gt;=01/01/2019";Orders!U:U;"&gt;=36";Orders!K:K;"&gt;=1")+COUNTIFS(Orders!D:D;"*Ecolab*";Orders!B:B;"&gt;=01/01/2019";Orders!U:U;"&gt;=36";Orders!L:L;"&gt;=1")+...........+COUNTIFS(Orders!D:D;"*Ecolab*";Orders!B:B;"&gt;=01/01/2019";Orders!U:U;"&gt;=36";Orders!Q:Q;"&gt;=1")</code> 
  But I would rather not include such a long formula as it would create confusion for the ultimate user of the excel sheet</p>