Sumrizing Data

Hi Asayehegn, Thank you for your question.

There are three main methods of summarising data not using Pivot Tables, and these are;

Subtotaling
Outlining
Consolidation

These options are covered in our Excel Courses Intermediate and Advanced, and are all quite in depth, perhaps if you wish to look at these methods then you could come back and we can give a much more focused attention to your needs.

regards Pete