![]() 2018 For this formula to work, the MAX function must always act on the whole range of sales values (so the range C4:C22 is fixed as $C$4:$C$22): 24 jun. Check Top row and Left column and click OK. This will have effectively expanded the named range by a cell. Apply Name to a new formula or existing formula quickly in Excel (Complete Guide). ![]() The value 10 is used in this formula because 10 is the original value of cell B2. SUMPRODUCT formula, the most dynamic Excel formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |