Excel Formula Help!


E

Elvis25uk

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
 
Ad

Advertisements

F

Flintstone

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top