SumProduct Help

D

Dan Oakes

I want to create a formula on Sheet1 that will give me the SUM of all
values on Sheet2 column G where the value in column B is = "x".

I think I need to use the SumProduct formula as an array to do this but
I'm not sure how to go about doing it.

Thanks,
Dan
 
B

Bob Phillips

One condition, SUMIF, much quicker than SUMPRODUC T.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

Dan Oakes

Thanks again guys...
- Dan

Bob said:
One condition, SUMIF, much quicker than SUMPRODUC T.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top