Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct forumla for complex sum.
I'm pretty sure this can be done with sumproduct, but I can't quite get my head around it. I have two tables, Tbl1 A & B, Tbl2 E & F. Both are limited to 15 rows. A B C E F 1 100 $100.00 100 $300 2 110 $50.00 130 $200 3 100 $25.00 120 4 $75.00 5 120 $120.00 The entries in col E of tbl2 are unique. What I'd like to do given this data is: - Sum tbl2 col F, - for each row in Tbl1, if item A is "" or isn't in tbl2 then add B value to the sum. - for each row in tbl1, if item A is found in tbl2 but F is "" then add B value. Given the data shown the sum would become: sum = (F1 + F2) + B2 + B4 + B5 = $300.00 + $200.00 + $50.00 + $75.00 + $120.00 Thanks a bunch, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex SUMPRODUCT/VLOOKUP/SUMIF | Excel Worksheet Functions | |||
Sumproduct syntax - more complex | Excel Discussion (Misc queries) | |||
sumproduct forumla, but I want difference instead of sum | Excel Worksheet Functions | |||
a complex use of sumproduct ? | Excel Programming | |||
Help with Complex SUMPRODUCT formula | Excel Worksheet Functions |