Friends, look at the chart given below, you must have seen this while watching a cricket match, the over by over record of both teams is presented in a line chart, but do you know how you can also make a MIS REPORT from this chart? For this, follow the steps given below.
If you make this chart on your own data then you will be able to impress all the members of your office.
1) First of all download the practice file from the link given below and insert a new sheet in it. In this sheet type the year 2018-19 and 2019-20 one below the other.
2) Now you have to type and drag from January to December in the row above these year sales.
3) Now create a drop down list of brands and then enter the SUMIFS formula like this…
=SUMIFS(Sheet1!$J:$J,Sheet1!$A:$A,Sheet4!E$2,Sheet1!$B:$B,Sheet4!$D3,Sheet1!$C:$C,Sheet4!$C$2)
If you liked these EXCEL TIPS mentioned here, then just tell us by commenting. To comment, visit this WEBSITE in desktop mode on your mobile, hope you will comment.
To read more blogs, click on the links given below.
0 Comments
Do leave your comments