Summarize data in excel 07 - TechRepublic
Question
January 15, 2013 at 07:14 AM
loveatallca

Summarize data in excel 07

by loveatallca . Updated 13 years, 5 months ago

How to summarize data by year or month from below table:
Date Sales US$ Customer name
01.01.2011 100 MAC
01.02.2011 200 MIS
01.03.2011 100 MIR
06.03.2011 400 LOS
01.01.2012 300 WIN
01.02.2012 500 COS
04.02.2012 600 MOS
How much sale is in 2011 and 2012 one figure summary each year or month wise

This discussion is locked

All Comments