two columns

[kylefoley76]

=(SUMPRODUCT($I$2:$I$3000,--($G$2:$G$3000=T$1),--($D$2:$D$3000=$S3)))*-1

I forget how you put two columns in your formula.

For example, I want two columns included where it says $I$2:$I$3000

what's the syntax?

 

[Jonmo1]

Perhaps this

=(SUMPRODUCT($I$2:$J$3000*($G$2:$G$3000=T$1)*($D$2:$D$3000=$S3)))*-1


Hope that helps.

 

[kylefoley76]

thanks but the columns aren't next to each other,

it's columns

I & p

 

[Jonmo1]

Try

=(SUMPRODUCT($I$2:$I$3000+$P$2:$P$3000*($G$2:$G$3000=T$1)*($D$2:$D$3000=$S3)))*-1

Change the + to * depending on your desired output..
If you want I and P SUMMED, then use +
If you want I and P Multiplied, then use *


Hope that helps.

 

[kylefoley76]

Ok, I rewrote the formula and I'm getting a #value! error message

=(SUMPRODUCT($I$2:$I$3000+$P$2:$P$3000,--($G$2:$G$3000+$N$2:$N$3000=T$1),--($D$2:$D$3000+$K$2:$K$3000=$S3)))*-1

 

[kylefoley76]

help

 

[Jonmo1]

This is why you should post exactly what you want, not a simplified version..

In this section
--($G$2:$G$3000+$N$2:$N$3000=T$1)
do you want G OR N = T1,
or do you want G AND N = T1
?

same question for the last section.

 

[kylefoley76]

I want G and N

 

[Jonmo1]

Try

=SUMPRODUCT($I$2:$I$3000+$P$2:$P$3000*($G$2:$G$3000=T$1)*($N$2:$N$3000=T$1)*($D$2:$D$3000=S$3)*($K$2:$K$3000=$S3))*-1

 

[kylefoley76]

I don't want to multiply things. That multiplied the numbers in the two columns, I want to add them.