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

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

=SUMPRODUCT(--(G1:G100),--(B1:B100="x"))

Enter as a regular formula, not an array. Adjust the ranges to suit your
needs.

Dave
--
Brevity is the soul of wit.


"Dan Oakes" wrote:

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

One condition, SUMIF, much quicker than SUMPRODUC T.

--
HTH

Bob Phillips

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

"Dave F" wrote in message
...
=SUMPRODUCT(--(G1:G100),--(B1:B100="x"))

Enter as a regular formula, not an array. Adjust the ranges to suit your
needs.

Dave
--
Brevity is the soul of wit.


"Dan Oakes" wrote:

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

Thanks again guys...
- Dan

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

--
HTH

Bob Phillips

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

"Dave F" wrote in message
...
=SUMPRODUCT(--(G1:G100),--(B1:B100="x"))

Enter as a regular formula, not an array. Adjust the ranges to suit your
needs.

Dave
--
Brevity is the soul of wit.


"Dan Oakes" wrote:

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

Glad to help

--
Don Guillett
SalesAid Software

"Dan Oakes" wrote in message
oups.com...
Thanks again guys...
- Dan

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

--
HTH

Bob Phillips

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

"Dave F" wrote in message
...
=SUMPRODUCT(--(G1:G100),--(B1:B100="x"))

Enter as a regular formula, not an array. Adjust the ranges to suit
your
needs.

Dave
--
Brevity is the soul of wit.


"Dan Oakes" wrote:

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