I'm trying to compose a formula which will count number of instances of a value within a given date range. My first attempt embarrassingly wrong:
Can anyone help me see how best to compose a formula that counts the number of times "Orange" appears in column G if the date in column A is between the parameters set in cells 500 and 501? I'm using "10/1/2011" in cell 500 and "12/30/2011" in cell 501.Please Login or Register to view this content.
Many thanks, in advance, to anyone who can assist!
Bookmarks