After Hours

Ask something
Discussion Locked

Summarize data in excel 07

0 helpful
3 replies

by loveatallca

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How to summarize data by year or month from below table:
Date sales
01.01.2011 100
01.02.2011 200
01.03.2011 100
06.03.2011 400
01.01.2012 300
01.02.2012 500
04.02.2012 600
How much sale is in 2011 and 2012 one figure summay or month wise

3 replies

by john.a.wills

This should be in Q & A - although I notice that a recent question of mine somehow did not get in the list...

This discussion is closed to new replies.