SUMPRODUCT
try:
=SUMPRODUCT((LEFT(Sheet1!$A$1:$A$9,2)={"90","91"}) *(RIGHT(Sheet1!$A$1:$A$9,5)="80111")*Sheet1!$B$1:$ B$9)
"Farhad" wrote:
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
|