<div>
I tried that but it didn't seem to work when I added the second criteria. Do I have to do anything different because that criteria is looking up a date?
</div>


I tried that but it didn't seem to work when I added the second criteria. Do I have to do anything different because that criteria is looking up a date?

<div>
Nevermind. It's working. I had today's date in there and it didn't match cause there were no records with today's date. Thank you for you help!
</div>


Nevermind. It's working. I had today's date in there and it didn't match cause there were no records with today's date. Thank you for you help!

<div>
<div class="content wysiwyg-content">
I'm trying to use a sumproduct formula with a sumifs and I can't seem to get it to work. I need to lookup the date in cell A4 and sum the values on my worksheet &quot;Invoices&quot; in column O and sum all the rows that have that date in column A where there is text in column J that has &quot;AR.00&quot; in it somewhere. Here's what I have but it doesn't seem to be working. What am I doing wrong?<br />
<br />

<pre><code id="code-10-28259518-1">SUMPRODUCT(--(Invoices!A2:A113='Master Dashboard'!A4),SUMIFS(Invoices!$O$2:$O$5000,Invoices!$J$2:$J$5000,&quot;*AR.00*&quot;))</code></pre>
</div>
</div>


I'm trying to use a sumproduct formula with a sumifs and I can't seem to get it to work. I need to lookup the date in cell A4 and sum the values on my worksheet "Invoices" in column O and sum all the rows that have that date in column A where there is text in column J that has "AR.00" in it somewhere. Here's what I have but it doesn't seem to be working. What am I doing wrong?

(CODE)

Sumproduct with Sumifs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.