Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumProduct
Hi all.
XP xl2003 After some struggling, I have managed to create the following formula in a procedure which works fine returning the correct result from a filtered list. However, I would like to include two more tests if possible before the result in INV_AMOUNT is returned. In the RECONCILIATION worksheet I have two cols (B & C) for firstname & Lastname so in addition to testing for invoice ID in Col E ( named range INV_APARID in INVOICE sheet ) I also need to test both B10 & C10 on reconciliation sheet against named ranges INV_FNAME & INV_LNAME in INVOICE worksheet before INV_AMOUNT is returned. However, I am not too sure how to include extra tests in the formula? ..Range("G10").Formula = _ "=IF($E10=$E9,0,SUMPRODUCT(SUBTOTAL(3,OFFSET(INV_A PARID,ROW(INV_APARID)-MIN(ROW(INV_APARID)),,1)),--(INV_APARID=RECONCILIATION!$E10),INV_AMOUNT))" Hope clear - any help / guidance appreciated. -- dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
sumproduct | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Discussion (Misc queries) |