PROMOTE YOUR BRAND WITH OUR PROGRAM
This space is reserved for your advertising message and web links.
The advertising message is limited to 10 lines or 500 characters.
The program is tailored individually for each client.
More info: http://www.utilities4promoting.com/calc-utilities/index.htm
TABLE (EXCEL) FORMULAS GENERATOR SUBTOTAL
Program for creating multi-level subtotal() formulas in MS Excel compatible tables.
This document was created using excel_sum_free.exe program.
Useful link added by the program www.bug.hr.exe:
http://www.bug.hr
Before using formulas, table must be sort on group of columns.
Column name for start sort = A
The number of columns in the group for sort = 4
Columns must be arranged in a compact group.
Column name with data (subtotal) = E
Row number (start) with data cell = 3
Column name with start of free area = G
--------------------
step = 1
=IF(A3<>A4;ROW();"")
Copy formula in cell G3.
Then copy formula from these cell by the end of the table.
--------------------
step = 2
=IF(OR(B3<>B4;G3<>"");ROW();"")
Copy formula in cell H3.
Then copy formula from these cell by the end of the table.
--------------------
step = 3
=IF(OR(C3<>C4;G3<>"";H3<>"");ROW();"")
Copy formula in cell I3.
Then copy formula from these cell by the end of the table.
--------------------
step = 4
=IF(OR(D3<>D4;G3<>"";H3<>"";I3<>"");ROW();"")
Copy formula in cell J3.
Then copy formula from these cell by the end of the table.
--------------------
step = 5
=IF(G3<>"";T("SUBTOTAL_01(A="&A3&", E)=");"")
Copy formula in cell K3.
Then copy formula from these cell by the end of the table.
--------------------
step = 6
=IF(G3<>"";SUM(INDIRECT("E"&TEXT((MAX(G$3:INDIRECT("G"&TEXT(ROW()-1;"#")))+IF(ROW()>3;1;0));"#")):INDIRECT("E"&TEXT(ROW();"#")));"")
Copy formula in cell L3.
Then copy formula from these cell by the end of the table.
--------------------
step = 7
=IF(H3<>"";T("SUBTOTAL_02(A="&A3&", B="&B3&", E)=");"")
Copy formula in cell M3.
Then copy formula from these cell by the end of the table.
--------------------
step = 8
=IF(H3<>"";SUM(INDIRECT("E"&TEXT((MAX(H$3:INDIRECT("H"&TEXT(ROW()-1;"#")))+IF(ROW()>3;1;0));"#")):INDIRECT("E"&TEXT(ROW();"#")));"")
Copy formula in cell N3.
Then copy formula from these cell by the end of the table.
--------------------
step = 9
=IF(I3<>"";T("SUBTOTAL_03(A="&A3&", B="&B3&", C="&C3&", E)=");"")
Copy formula in cell O3.
Then copy formula from these cell by the end of the table.
--------------------
step = 10
=IF(I3<>"";SUM(INDIRECT("E"&TEXT((MAX(I$3:INDIRECT("I"&TEXT(ROW()-1;"#")))+IF(ROW()>3;1;0));"#")):INDIRECT("E"&TEXT(ROW();"#")));"")
Copy formula in cell P3.
Then copy formula from these cell by the end of the table.
--------------------
step = 11
=IF(J3<>"";T("SUBTOTAL_04(A="&A3&", B="&B3&", C="&C3&", D="&D3&", E)=");"")
Copy formula in cell Q3.
Then copy formula from these cell by the end of the table.
--------------------
step = 12
=IF(J3<>"";SUM(INDIRECT("E"&TEXT((MAX(J$3:INDIRECT("J"&TEXT(ROW()-1;"#")))+IF(ROW()>3;1;0));"#")):INDIRECT("E"&TEXT(ROW();"#")));"")
Copy formula in cell R3.
Then copy formula from these cell by the end of the table.