00:00With this one simple Excel technique, it will save you hours and hours of spreadsheet duty.
00:05Check this out. The goal is to calculate the cumulative quantity for each fruit in column M
00:09from dataset Q1 to Q4. Just a note, Q1 and Q4 dataset could possibly be in a different worksheet
00:15or workbook for the matter of fact. Now, you're not going to do this horrible manual approach to
00:19search and add the quantities like this, but instead, take this smarter approach.
00:24We'll start off by placing our cursor on cell M9. When you go to data on your ribbon,
00:28data tools, consolidate, and on the function, make sure you select it as sum,
00:32and then click on reference and select the data set in Q1 excluding the header.
00:37And after that, click on add. Repeat the last two steps for Q2, Q3, and Q4.
00:42And after that, make sure you put a check on the left column and click on OK.
00:46And that's how we sum the quantity of all common fruits together.
00:49Using the same technique, you can also perform count function by simply changing the function
00:53to count in your consolidation pop-up.
00:58And there are two things on the bottom left one and our annual cupcakeγι‘γγγΎγ.
00:58And then click on the left table andγγγγ the overall Securi tab by default.
00:58If you λ look to the data set up frame and Shelley.
Comments