I am currently using this formula for 1 cell =SUMPRODUCT(--(SOPLIVE!$A$66533:$A$69522=A11), --(SOPLIVE!$H$66533:$H$69522="Oct-2017"), SOPLIVE!$C$66533:$C$69522)

This is correct and does what I need it to up to a point....

The SOPLIVE sheet is connected to a Microsoft Query. I need to add another two criterias on that MSQUERY so that the sheet does not include any cancelled orders, or completed orders. I can do this and it seems to work before I have returned the data.

However, when I then click 'return data' it returns to excel with no data on that sheet?

What I need is the =SUMPRODUCT(--(SOPLIVE!$A$66533:$A$69522=A11), --(SOPLIVE!$H$66533:$H$69522="Oct-2017"), SOPLIVE!$C$66533:$C$69522) formula to only pick up orders filtered by not including cancelled or completed.

Or for the criteria within the MSQUERY to work when I return the data.

Really stuck with this one guys! Not sure why it isn't working.

If anything is unclear, please message for more details.

All help is appreciated!

Natheplas