Multiple Sumproduct equation

[Hoosier03]

I am using excel 2007. This is my equation that is not working and I cannot figure out why. It returns a number, but the number is not correct.


=IF(E$4="f",SUMPRODUCT(('AOP Query'!$G$22:$G$440=$C8)*('AOP Query'!$BI$22:$BL$440)),SUMPRODUCT(('Actual Query'!$H$22:$H$440=$C8)*('AOP Query'!$BJ$22:$BM$440)))


What I am trying to do is if E$4 equals "F" to add data from one worksheet (AOP query). If it does not I would like to add it from another worksheet (Actual query). I know the first part of the equation is right because I used it successfully in a different worksheet.


Thanks for your help.

 

[doublej_jj]

Your question is very vague.

Is AOP Query and Actual Query identical in format? If so, whatever you have in C8 is being looked up in column G on AOP Query and column H on Actual Data? Should they be the same column?

Just a place to start.

Jeff

 

[Hoosier03]

The column lookups are correct. I figured out half of my problem was that the end of the equation was referencing the AOP query when it should have been referencing the Actual query, but it is still not right.

 

[Hoosier03]

I figured out the problem. Thanks for your help.