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.
|