#### silentcoates

##### New Member

- Joined
- Oct 11, 2005

- Messages
- 41

this is another difficult one to explain, but here goes.

I am producing a spreadsheet that has to produce data on a weekly basis. I need a

formula, if there is one, that can pull information from a sheet between two dates.

example:

in cell A3 I have a list of dates of when the data was entered. In the other columns I

have various bits of data (B - Names, C- a score as a percentage, D - a yes no

value). I need a formula for each bit of data. So on another sheet I need to show

say the average score for a person between two date ranges, on another the number

of yes values between the same dates. I understand I will need to enter slightly

different formulas depandent on the data I am looking at.

Also I need to count the number of times a persons name appears in column B

between two dates.

Hope you can help.