a simple SUMIF should do. Look in the help index

--
Don Guillett
SalesAid Software

"Dan Oakes" wrote in message
ups.com...
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