See help on subtotals. This should answer your questions
HTH

"AcesUp" wrote:


All,

I am trying to perform the following tasks within Excel.

Task 1

I have three columns, Date, Game, Score.

Is there a way I can request that Excel only display rows that fall
withinn a cetain date range?

Task 2

Once I have the refined data I would like to consolidate it. I.e
Several games might have been played on the same date I would like to
just have one row per date per game with the score totalled. So if two
games of bowling were played on 21/07/05 with score of 163 and 187. The
row would read,

----A------------B-----------C
21/07/05---Bowling-----350

You get the idea! ;)

Thanks in advance.
AU


--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile: http://www.excelforum.com/member.php...o&userid=26519
View this thread: http://www.excelforum.com/showthread...hreadid=397877