SUMPRODUCT trciky use.
 

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.

SUMPRODUCT trciky use.
 

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.

SUMPRODUCT trciky use.
 

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.

SUMPRODUCT trciky use.
 

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.

SUMPRODUCT trciky use.
 

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.