Hi All,
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
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