I'm new to the consolidation feature in Excel. I have shared a link to the drive doc in google.
https://docs.google.com/spreadsheets/d/1SJ7e85R5Hm1Nc6DQRJcYAhl4PPfX3lV7HfbZq4xrOuw/edit?usp=sharing
I have some columns which are in percentages (conversion column), I would like to sum these and then divide by the number of rows which it appears in, to get an average. The rest of the rows can be summed.
Maybe the answer goes beyond consolidation, i'm happy to explore more complicated ways to perform this, as I have a big data set I need to deal with.
Thanks
https://docs.google.com/spreadsheets/d/1SJ7e85R5Hm1Nc6DQRJcYAhl4PPfX3lV7HfbZq4xrOuw/edit?usp=sharing
I have some columns which are in percentages (conversion column), I would like to sum these and then divide by the number of rows which it appears in, to get an average. The rest of the rows can be summed.
Maybe the answer goes beyond consolidation, i'm happy to explore more complicated ways to perform this, as I have a big data set I need to deal with.
Thanks
