sumproduct
Hi,
My data is like below:
A B
1 900180111 50000
2 902180111 20000
3 911180111 15000
4 900180121 40000
5 911280121 150000
what i want to do is:
sum of column B which the code in the column A started with 90 or 91 and
ended with 80111 the answer suld be 35000
any help would be appriciated.
Farhad
--
Farhad Hodjat
|