Hey Guys,

I was looking for help that I think may be quicker to ask then try to go back and figure it out for a few hours.

I have two worksheets. Sheet 1 is named = Summary
Sheet 2 is named = RawData_cYTD_2014

On Summary Sheet in Cell b4 this is what I am attempting to sum all from the RawData_cYTD_2014.

I want to (sum column AB) only if (Column N is between 1/01/2014 and 1/31/2014) and (Column X contains the text apple).

thanks so much

-richtree