How to SUMIF a Range having particular Series

[petes]

Guys -

I need a formula in Sheet1 Column B. The exact matching criteria may not be in Sheet2, but it need take the series (Eg: 11 & 12) and compare with Sheet1. Hope the example below with coloring is helpful. Thanks!


Sheet 1

Series	Need formula below?? (Amount)
11-00-00	3000
12-00-00	5000

<tbody>
</tbody>

Sheet 2

Series	Amount
11-00-01	1000
11-00-02	500
11-00-03	500
11-00-05	1000
12-00-02	2500
12-00-03	2500

<tbody>
</tbody>

 

[Peter_SSs]

See if something like this could be used. Adjust ranges of course.

Excel Workbook
	A	B
1	Series	Sum
2	11-00-00	3000
3	12-00-00	5000
Sheet1

 

[petes]

Thank you very much! its working

 

[Peter_SSs]

Thank you very much! its working

Cheers. Thanks for the follow-up.