Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Help with SUMPRODUCT | Excel Discussion (Misc queries) | |||
sumproduct | Excel Worksheet Functions | |||
Sumproduct help | Excel Worksheet Functions |