TABLE OF CONTENTS
    1. EXCEL-SUM-FREE, excel_sum_free.exe, free version, free distribution, advertising depends on the naming/renaming of the program 1. 
    2. DESCRIPTION OF OPERATION 2. 
        2.1 COPYING AND RENAME THE PROGRAM TO PROMOTE YOUR BRAND 2.1 
        2.2 PLACING FORMULAS IN TABLES 2.2 
        2.3 MULTI-LEVEL SUBTOTALS 2.3 
        2.4 SUMMARIZATION BY GROUPS, OPTION A 2.4 
        2.5 SUMMARIZATION BY GROUPS, OPTION B 2.5 
    3. DATA SECURITY AND PROTECTION OF USER PRIVACY 3. 
    4. EXCEL-SUM-PAID, excel_sum_paid.exe, paid version, free distribution, permanent advertising 4. 
    5. PROMOTE YOUR BRAND WITH OUR OTHER PROGRAMS (utilities4promoting) 5. 



Last change (yyyy.mm.dd): 2026.02.10


    1. EXCEL-SUM-FREE, excel_sum_free.exe, free version, free distribution, advertising depends on the naming/renaming of the program
    The program is intended for providers of goods and services who advertise online.
    The program is free and has no restrictions on copying or distribution.
    
    
    2. DESCRIPTION OF OPERATION
    Based on minimal input data, the program generates a group of MS Excel formulas for three common forms of summarization in MS Excel tables.
    The offered formulas only need to be transferred (copy, paste) to MS Excel tables and the calculation (summarization) is performed immediately
    without additional editing.
    Of course, it is also possible to additionally upgrade the formulas interactively.
    The program allows:
    - multilevel subtotals
    - summation by groups, variant A
    - summation by groups, variant B
    
        2.1 COPYING AND RENAME THE PROGRAM TO PROMOTE YOUR BRAND
        The excel_sum.free.exe program is a free program, but it must be renamed to actually work.
        The program promotes your website by inserting your web link into the output file with formulas.
        The program decomposes the web address of your web portal from the program name, so the excel_sum_free.exe program must be copied
        and renamed accordingly.
        
        Rename the program according to the address of your website, but the condition is that the new program name begins
        with http..., https..., www...
        URL: http://alsoldbooks.com , renamed program: http.alsoldbooks.com.exe
        URL: https://alsoldbooks.com , renamed program: https.alsoldbooks.com.exe
        URL: http://www.alsoldbooks.com , renamed program: www.alsoldbooks.com.exe
        URL: https://www.alsoldbooks.com , renamed program: www.alsoldbooks.com.exe
        
        2.2 PLACING FORMULAS IN TABLES
        Before using the program, it is necessary to foresee and provide space for placing the formulas in the table.
        In certain cases, it is necessary to create a separate table just for the needs of placing formulas.
        Program write formulas and placement instructions in output files:
        - efg_subtotal.htm
        - efg_sumif_01.htm
        - efg_sumif_02.htm
        
        2.3 MULTI-LEVEL SUBTOTALS
        The program generates formulas for subtotals.
        Demo examples were created using the excel_sum_free.exe program, which was copied and renamed to www.bug.hr.exe
        Subtotals are based on the number of columns that define the keys for sorting data.
        The data in the table must be previously sorted by a compact group of sort keys (sort columns).
        Demo file with formulas: http://www.utilities4promoting.com/calc-utilities/excel-sum-free/subtotal/efg_subtotal.htm 
        Demo tables            : http://www.utilities4promoting.com/calc-utilities/excel-sum-free/subtotal/subtotal.7z 
        Free program, subtotal : http://www.utilities4promoting.com/calc-utilities/excel-sum-free/subtotal/excel_sum_free.exe 
        
        2.4 SUMMARIZATION BY GROUPS, OPTION A
        Demo examples were created using the excel_sum_free.exe program, which was copied and renamed to www.bug.hr.exe
        In cases where it is not possible to reorganize and sort the table according to the desired sort keys,
        summarization by key groups is used.
        Demo file with formulas: http://www.utilities4promoting.com/calc-utilities/excel-sum-free/sumif_01/efg_sumif_01.htm 
        Demo tables            : http://www.utilities4promoting.com/calc-utilities/excel-sum-free/sumif_01/sumif_01.7z 
        Free program, sumif_01 : http://www.utilities4promoting.com/calc-utilities/excel-sum-free/sumif_01/excel_sum_free.exe 
        
        2.5 SUMMARIZATION BY GROUPS, OPTION B
        Demo examples were created using the excel_sum_free.exe program, which was copied and renamed to www.bug.hr.exe
        Variant B is basically the same as variant A, but the placement of the formulas is different, and
        the operation is more interactive and graphic.
        Demo file with formulas: http://www.utilities4promoting.com/calc-utilities/excel-sum-free/sumif_02/efg_sumif_02.htm 
        Demo tables            : http://www.utilities4promoting.com/calc-utilities/excel-sum-free/sumif_02/sumif_02.7z 
        Free program, sumif_02 : http://www.utilities4promoting.com/calc-utilities/excel-sum-free/sumif_02/excel_sum_free.exe 
        
        
    3. DATA SECURITY AND PROTECTION OF USER PRIVACY
    The paid version of program does not connect to the web, does not display third-party ads,
    and does nothing that could compromise data security and user privacy.
    
    
    4. EXCEL-SUM-PAID, excel_sum_paid.exe, paid version, free distribution, permanent advertising
    http://www.utilities4promoting.com/calc-utilities/excel-sum-paid/index.htm 
    
    
    5. PROMOTE YOUR BRAND WITH OUR OTHER PROGRAMS (utilities4promoting)
    The programs have a dual purpose. They are computer tools for increasing personal productivity
    and at the same time a marketing and communication channel for online providers of goods and services.
    The common feature of the programs is that they index the output *.HTML files for all words that have
    at least three (3) letters and place advertising messages in the index of all words.
    The programs are customized for each customer and retrieve advertising messages from the web address
    defined by the customer of the program when ordering.
    http://www.utilities4promoting.com/index.htm 

This document was structured using the TXT-INDENT program.
More info: www.utilities4promoting.com