Hi,

I am tryong to us the SUMPRODUCT function but I am wondering if I am in the
right path...

Here is waht I have :

Taxe1 Taxe2 Total
x x 100
x 110
x 120

Taxe1 & Taxe2 are define as Names.

I want to have the grand total with taxes.

So I tried:

SUMPRODUCT(E10:E13,IF(B10:B13="x",1+GSTTPS,1),IF(C 10:C13="x",1+PSTTVQ,1))

The formula does note return any error, but I have a #VALUE :(

Any idea on how to work that out.

Thanks,
Nde
PS: there are some reasons for not entering the tax values...just making it
simple for you.

Maybe you can explain what you are trying to do instead of posting a formula
that clearly doesn't work but makes it hard for us to guess what you want.

=SUMPRODUCT((B10:C13="x")*(E10:E13))


will sum E10:E13 where B10:C13 is "x"


--


Regards,


Peo Sjoblom



"Nde" wrote in message
...
Hi,

I am tryong to us the SUMPRODUCT function but I am wondering if I am in
the
right path...

Here is waht I have :

Taxe1 Taxe2 Total
x x 100
x 110
x 120

Taxe1 & Taxe2 are define as Names.

I want to have the grand total with taxes.

So I tried:

SUMPRODUCT(E10:E13,IF(B10:B13="x",1+GSTTPS,1),IF(C 10:C13="x",1+PSTTVQ,1))

The formula does note return any error, but I have a #VALUE :(

Any idea on how to work that out.

Thanks,
Nde
PS: there are some reasons for not entering the tax values...just making
it
simple for you.

Try this:

=SUMIF(B10:B13,"X",E10:E13)*(1+GSTTPS)+SUMIF(C10:C 13,"X",E10:E13)*(1+PSTTVQ)

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Nde" wrote in message
...
Hi,

I am tryong to us the SUMPRODUCT function but I am wondering if I am in
the
right path...

Here is waht I have :

Taxe1 Taxe2 Total
x x 100
x 110
x 120

Taxe1 & Taxe2 are define as Names.

I want to have the grand total with taxes.

So I tried:

SUMPRODUCT(E10:E13,IF(B10:B13="x",1+GSTTPS,1),IF(C 10:C13="x",1+PSTTVQ,1))

The formula does note return any error, but I have a #VALUE :(

Any idea on how to work that out.

Thanks,
Nde
PS: there are some reasons for not entering the tax values...just making
it
simple for you.

Nde,

That is one of the special SUMPRODUCT cases that requires Array entry: use Ctrl-Shift-Enter instead
of just enter.

HTH,
Bernie
MS Excel MVP


"Nde" wrote in message
...
Hi,

I am tryong to us the SUMPRODUCT function but I am wondering if I am in the
right path...

Here is waht I have :

Taxe1 Taxe2 Total
x x 100
x 110
x 120

Taxe1 & Taxe2 are define as Names.

I want to have the grand total with taxes.

So I tried:

SUMPRODUCT(E10:E13,IF(B10:B13="x",1+GSTTPS,1),IF(C 10:C13="x",1+PSTTVQ,1))

The formula does note return any error, but I have a #VALUE :(

Any idea on how to work that out.

Thanks,
Nde
PS: there are some reasons for not entering the tax values...just making it
simple for you.

Oops! I missed a key part of your formula....

Using the SUMPRODUCT approach...

try this regular formula:
=SUMPRODUCT(E10:E13,1+((B10:B13="x")*GSTTPS+(C10:C 13="x")*PSTTVQ))

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Ron Coderre" wrote in message
...
Try this:

=SUMIF(B10:B13,"X",E10:E13)*(1+GSTTPS)+SUMIF(C10:C 13,"X",E10:E13)*(1+PSTTVQ)

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Nde" wrote in message
...
Hi,

I am tryong to us the SUMPRODUCT function but I am wondering if I am in
the
right path...

Here is waht I have :

Taxe1 Taxe2 Total
x x 100
x 110
x 120

Taxe1 & Taxe2 are define as Names.

I want to have the grand total with taxes.

So I tried:

SUMPRODUCT(E10:E13,IF(B10:B13="x",1+GSTTPS,1),IF(C 10:C13="x",1+PSTTVQ,1))

The formula does note return any error, but I have a #VALUE :(

Any idea on how to work that out.

Thanks,
Nde
PS: there are some reasons for not entering the tax values...just making
it
simple for you.