Home > Sanjeewa's questions
Below are Sanjeewa's Questions. Did not find what you want
Click here to ask a question of your own
Category: MS Excel

Hi,

I have a lot of data of sales which is relevant to whole seller business. There are three different categories of sales. Those are Cash sales, Check sales, Credit sales. I have Excel files for each month including daily sales of different items. Please see below image.

What I want is I want to summarize those monthly data to show total amount of each item under each category. Like this,

Can anybody tell me an easy way to do this?

Category: MS Excel

I have excel work books with about 200 sheets. I want to apply same formulas to every sheet .Is there a way to do it at the same time. please help.