Sumproduct with Sumifs

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?

SUMPRODUCT(--(Invoices!A2:A113='Master Dashboard'!A4),SUMIFS(Invoices!$O$2:$O$5000,Invoices!$J$2:$J$5000,"*AR.00*"))

Open in new window

Lawrence SalvucciInformation Technology ManagerAsked:
Who is Participating?
barry houdiniConnect With a Mentor Commented:
I think you might want SUMIFS on its own like this

=SUMIFS(Invoices!$O$2:$O$5000,Invoices!$J$2:$J$5000,"*AR.00*",Invoices!$A$2:$A$5000,'Master Dashboard'!A4)

Does that do what you need?

regards, barry
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
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?
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
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!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.