Hello, need help with excel formula, basically I have two worksheets, 1
woorksheet will have events with a specfic date and another worksheet which
summerises the events by a date range e.g
worksheet 1 worksheet 2
column A Column B column A column B
Wet 04/01/2010 w/c 04/01/2010 2
Cold 06/01/2010 w/c 11/01/2010 1
Hot 12/01/2010

At present the results would show in worksheet 2 as above, which I can input
manually but would like a formula to link the worksheets, by a formula which
counts up the events in worksheet 1 by specific dates e.g 04/01/2010
-10/01/2010 e.g weekly? Hope you can help

Hey Elvis. . . What version of Excel are you using?
Take a look at 2007's new formula CountIFS. . . From what you have described
below, it sounds like this may be what you are looking for?

CountIFS will count the number of values in a table and return results in a
separate worksheet.





"Elvis25uk" wrote:

Hello, need help with excel formula, basically I have two worksheets, 1
woorksheet will have events with a specfic date and another worksheet which
summerises the events by a date range e.g
worksheet 1 worksheet 2
column A Column B column A column B
Wet 04/01/2010 w/c 04/01/2010 2
Cold 06/01/2010 w/c 11/01/2010 1
Hot 12/01/2010

At present the results would show in worksheet 2 as above, which I can input
manually but would like a formula to link the worksheets, by a formula which
counts up the events in worksheet 1 by specific dates e.g 04/01/2010
-10/01/2010 e.g weekly? Hope you can help

You want a Pivot Table. Check out http://www.cpearson.com/excel/pivots.htm,
and post back if you have further questions.

Regards,
Fred

"Elvis25uk" wrote in message
...
Hello, need help with excel formula, basically I have two worksheets, 1
woorksheet will have events with a specfic date and another worksheet
which
summerises the events by a date range e.g
worksheet 1 worksheet 2
column A Column B column A column B
Wet 04/01/2010 w/c 04/01/2010 2
Cold 06/01/2010 w/c 11/01/2010 1
Hot 12/01/2010

At present the results would show in worksheet 2 as above, which I can
input
manually but would like a formula to link the worksheets, by a formula
which
counts up the events in worksheet 1 by specific dates e.g 04/01/2010
-10/01/2010 e.g weekly? Hope you can help