![]() You need to watch out though, because when you define a static named range like I did in the video you might forget to expand the range when there’s new data. Named ranges make it easier to read formulas. ![]() You can’t use spaces in named ranges so I used an underscore when creating the named range “sales_person” – Excel doesn’t accept “sales person” as a named range. The nice thing about named ranges is that you can customize them and call them something that’s memorable and easy to read. In the first formula, “sales_person”, “criteria_1” and “sales” are named ranges that point to cells on the worksheet. = SUMIF ( sales_person, criteria_1, sales ) ![]() Named ranges are important to understand and use because they make it easier to read formulas. If you have any trouble watching the Youtube video embedded above, you can view the video on YouTube by clicking here.Ġ:58 – Named range tricks (Ctrl + F3 to bring up name manager, Ctrl + Shift + F3 to create named range from selection)ġ:52 – Create unique list of names (using Excel’s Remove duplicates feature, available in Excel 2007+)Ģ:30 – Set up data validation drop down list, sourced from a defined named rangeģ:35 – SUMIF() formula (total lifetime sales)Ĥ:21 – COUNTIF() formula (number of months with sales)ĥ:04 – AVERAGEIF() formulas (average monthly sales)ĥ:49 – Using drop down list to select new sales person, formulas automatically recalculate Use Python Xlsxwriter To Create Excel Formulas And Links (Part 2)
0 Comments
Leave a Reply. |