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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Series[/TD]
[TD]Need formula below?? (Amount)[/TD]
[/TR]
[TR]
[TD]11-00-00[/TD]
[TD]3000[/TD]
[/TR]
[TR]
[TD]12-00-00[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2

[TABLE="width: 500"]
<tbody>[TR]
[TD]Series[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]11-00-01[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]11-00-02[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]11-00-03[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]11-00-05[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]12-00-02[/TD]
[TD]2500[/TD]
[/TR]
[TR]
[TD]12-00-03[/TD]
[TD]2500[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.