How do I filter data which fall between two dates(variable) with two criteria.


Data is entered in rows (4 to 100). Row 3 are all the headings (A to G).

Date from= cell A2.
Date to= cell B2

Cell A4 = date
Cell B4 = criteria 1
Cell C3 = criteria 2
Cell G4 = number to extract. Result to appear in cell A4.

Thank you
--
Geo