G'Day everyone:
Sorry I know there are numerous posting on this topic however I have searched them and I am still having problems. I am trying to sumif with two conditions which I understand is not possible so I am using sumproduct.
I am trying to compute the revenue for several project numbers within a certain month. For example, I have project numbers 171610, 189430, and 192310 I want to find out how much revenue was recongized within the month of April.
Here are a couple formulas that I have been using:
=SUMPRODUCT(('Actual Rev'!B2:B7776=I7)*('Actual Rev'!Q2:Q7776='Summary Page'!A8)*('Actual Rev'!Q2:Q7776='Summary Page'!A9)*('Actual Rev'!Q2:Q7776='Summary Page'!A10)*('Actual Rev'!Q2:Q7776='Summary Page'!A11)*('Actual Rev'!Q2:Q7776='Summary Page'!A12)*('Actual Rev'!Q2:Q7776='Summary Page'!A13)*('Actual Rev'!Q2:Q7776='Summary Page'!A14)*('Actual Rev'!Q2:Q7776='Summary Page'!A15)*('Actual Rev'!U2:U7776))
Where I7 equals the month and Summary Page!A8 equals the project number. This returns a zero.
If I seperate by Project for example everything seems to work fine. I have also tried to define the project numbers but this returns #N/A.
What am I doing wrong? I am new to arrays but from the other posts I can get those examples right I just can't get the formulea to work right on my data. Thanks for the help in advance.
Cheers,
Jason