Dear Lalit

Thanks for your help. These are really interesting formulas.

Your second formula did not work and Excel Fox assisted me here http://www.excelfox.com/forum/f2/sum...eric-text-891/

He changed it to =SUM(IFERROR((INT(SUBSTITUTE(Sheet1!$C$5:$C$1000," D","0")) >= 30000)*(INT(SUBSTITUTE(Sheet1!$C$5:$C$1000,"D","0" )) <= 30150)*(Sheet1!$E$5:$E$1000),0)

Once again thanks for your help, which is most appreciated