Now that I've copied them, I can easily build my SUM formula without having to retype them:Īll I had to do is start my SUM formula with =SUM(, then click on the first XLOOKUP formula I copied, type in a colon, then click on the second XLOOKUP formula, and close my SUM function with a parenthesis. Notice that I copied the formulas (using the keyboard shortcut Ctrl + C) without the equal signs. So I don't have to read type these two formulas that I just created, I am going to use the Clipboard to make it easier to build this formula: Now what I want to do is SUM up the values between those. I am first going to create the formulas to look up the item for the From: – Prod3 and To: – Prod8. As I mentioned this is only available in Office 365. I have a list of 20 products and their values and I want to be able to choose two of the different products and get the SUM of the values between those two products: When you get a preview, look for Download in the upper right hand corner.
You can download the file here and follow along. Excel, and in the process of testing it, learned a really interesting feature. This is a trick I learned from Bill Jelen, Mr. In this tutorial we are going to learn how to use the XLOOKUP function to SUM a dynamic range of values in Excel.
0 kommentar(er)
