| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM formula after HLOOKUP result true
If I had data:
Sheet1: A B C 1 AAA BBB CCC 2 1 4 7 3 2 5 8 4 3 6 9 Sheet2: A B 1 CCC 24 2 BBB 15 3 AAA 6 Where B2 is the sum of Sheet1: C2-C4, after HLOOKUP function in cell A1, as well as B3 and B4 cells, do HLOOKUP sum based on the results. Is there a formula that can meet these conditions? Thank you for the information. Regards, Maulwy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show text massege when formula result is true | Excel Worksheet Functions | |||
| result if a condition is NOT true? | Excel Worksheet Functions | |||
| If formula true result then divided into 2 columns | Excel Worksheet Functions | |||
| How do I highlight a formula result (IF statment=True) | Excel Worksheet Functions | |||
| if logical test true, then hlookup, if false then difference betwe | Excel Worksheet Functions | |||
Threaded Mode
