Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
Hi,
My Data is like below: A B 1 900180111 40000 2 902180111 15000 3 900180121 52000 4 900180131 47000 5 911180111 13000 6 912880111 450 7 911180121 19000 8 914580131 55000 9 920180111 115000 what i want to do is: sum of column B wich the code in column A started with 90 or 91 and ended with 80111 so in this example the answer is: 68450 i know auto filter but i want this in another sheet. any help would be so appriciated. Thanks, -- Farhad Hodjat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct + | Excel Discussion (Misc queries) | |||
Sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct ?? | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |