Multiple criteria help

[akasdr]

Hello,
I'm having trouble being able to bring back the correct information with the formula below.

I am trying to bring back data, sum it, from a specific calendar month.

Thank you,
Rick


=SUMPRODUCT(SUMIF(INDIRECT("'Wip Reporting'!N4814:N8000"),$A5,INDIRECT("'Wip Reporting'!av4814:av8000")))+SUMIFS('Wip Reporting'!$AV4814:$AV8000,'Wip Reporting'!$G4814:$G8000,">="&U$4,'Wip Reporting'!$G4814:$G8000,"<="&EOMONTH(U$4,0))

[oeldere]

I woud solve this with a pivot table.


HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.