title: MAXIFS excel formula returning 0
body: <p>I have a table of transactions and transaction amounts in excel. I am using this forumula to determine the max before a certain date.</p>
  
  <p>=MAXIFS(Transactions[Amount],Transactions[Rec Date],Transactions[Rec Date]&amp;"&lt;="&amp;A2)</p>
  
  <p>A2 in this case equals the date 11/1/16. The forumula returns the value 0.</p>
  
  <p>Any reason this formula is not doing what I want? I have verified the data contains transactions above zero for dates prior to 11/1/16.</p>