title: Sumif Based on Multiple Criteria and Text Color
body: <p>I am using a Macro to Sum up Values of a specific Debtor.  It currently works fine but I need to add another Criteria;</p>
  
  <pre><code>Range("DebtorList_Payed")=Application.SumIf(Range("InvoiceList_Table_ItmCode"), _
    Range("Debtor_list_Debtors"), Range("InvoiceList_Price"))
  </code></pre>
  
  <p>I have another Range on the Invoice List Worksheet called Range("InvoiceList_Payed") in this row there is "CASH", "CREDIT", "(Custom) CASH" &amp; "(Custom) CREDIT".</p>
  
  <p>The text in the "CASH" &amp; "(Custom) CASH" Rows is Green
  and the text in the "CREDIT" &amp; "(Custom) CREDIT" Rows is Red</p>
  
  <p>Using the existing Macro I need for it to only sum the Rows which in the corresponding Range("InvoiceList_Payed") the Text Color is Green,</p>
  
  <p>So something like;</p>
  
  <pre><code>Range("DebtorList_Payed")=Application.SumIf(Range("InvoiceList_Table_ItmCode"), _
    Range("Debtor_list_Debtors"), Range("InvoiceList_Price") = _  
    Range("InvoiceList_Payed")&gt; "Green"))
  </code></pre>