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.