Hi All,

I'm trying to create a formula that will search for a specific text in "sheet1" within a date range and then SUM the total on "sheet2". I've manage to use the SUMPRODUCT (below) formula but want to expand on this so the SUM can be shown on another sheet(summary page). =SUMPRODUCT((ISNUMBER(FIND({"nmlclex06"},A1:A10)))*(B1:B10)) In this example I search for the text "nmlclex06" and SUM the size, but don't have a date range and don't know how to SUM the data on another sheet. Can someone please assist?



Columns: Name, Size, Date
nmlclex06 1 14/12/2013
nmlclap12 10 12/12/2013
nmlclex06 5 1/10/2013
nmlclex06 1 9/10/2013
nmlclex06 1 1/01/2014
nmlclap12 1 24/10/2013
nmlclex06 1 13/11/2013
nmlclap12 1 18/12/2013
nmlclap12 1 9/12/2013
nmlclap12 1 30/12/2013

Thanks.