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

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