Data consolidation

Hi,

I have workbook attached and is named as ‘DataDump’. It has the following worksheets

1.      Sheet 1
2.      Sheet 2

In ‘Sheet1’ workbook we have the name of the companies listed in column A. We are trying to get the total points received for each company for each month by comparing the data which is there in ‘Sheet2’.

I have used an array to get the data and it is perfectly working. I know that we can also use pivot to get this numbers from ‘Sheet2’. The only problem which I am facing is that it is literally making excel slow while calculating. I also know that while working on excel we can make the calculations to ‘Manual’ which would make excel to work faster. Is there is way where on click of a button all the calculations should be done (basically a macro to do this) and display the results as shown in the example attached. Please advise.

Regards,
Prashanth
DataDump.xlsx
pg1533Asked:
Who is Participating?
 
AgneauConnect With a Mentor Commented:
Hi Prashanth,

Instead of working with matrix formulas (very powerful, however poor perfomance depending on their construction), Excel now implements a function SUMIFS that can be used to sum a range according to more than one criteria.

Check the example attached

Regards
DataDump.xlsx
0
 
pg1533Author Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.