SUMIFs issue, VERY CONFUSING ISSUE

[icewing726]

Hi guys, I have a huge budget sheet that I use formulas to update data from queries rather than vba to update each cell (shaves a minute or two off the updates)

Here's my issue. I need this sumifs to work on the page but the two criteria don't work together and they should. Separately they work.
=SUMIFS(InvoiceData!D:D,InvoiceData!A:A,B12,InvoiceData!B:B,"paid")

Oh and this works as well when its on the InvoiceData Page

=SUMIFS(D:D,A:A,201900855,B:B,"paid") (B12 was referencing 201900855 on the other page)

Again separately they work. Together they work if they are on that page... this is maddening.

(NOTE: The '' disappear from around InvoiceData even after I add them back in so that shouldn't be the issue)

Help me mrexcel.com, you're my only hope!

 

[mole999]

just a thought, can you name the range ?

 

[icewing726]

Thanks for the reply bud...

Literally just got back to my desk after avoiding flipping it....

Life's hard but it's a lot harder when you're stupid.

It returned 0 because it was in the APPR status not PAID... 2.5 hours wasted because I can't read.