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 SUMIF_01
Program for creating sumif() formulas in MS Excel compatible tables.
This document was created using the excel_sum_free.exe program.
Useful link added by the program www.bug.hr.exe:
http://www.bug.hr
Introduction
Column name for creating group = C
Column name with data = D
Row number start with data cell = 3
Column name start with free area = G
--------------------
step = 1
=SUMIF(C:C;C3;D:D)
Copy formula in cell G3.
Then copy formula from these cell by the end of the table.
--------------------
step = 2
=COUNTIF(C$3:C3;C3)
Copy formula in cell H3.
Then copy formula from these cell by the end of the table.
--------------------
step = 3
=IF(AND(H3=1;G3<>0);G3;"")
Copy formula in cell I3.
Then copy formula from these cell by the end of the table.
--------------------
step = 4
=COUNT(I$3:I3)
Copy formula in cell J3.
Then copy formula from these cell by the end of the table.
--------------------
step = 5
=C3
Copy formula in cell K3.
Then copy formula from these cell by the end of the table.
--------------------
step = 6
=I3
Copy formula in cell L3.
Then copy formula from these cell by the end of the table.
--------------------
step = 7
=ROW()-COUNT(J:J)-(3-1)
Copy formula in cell M at the end of table + 1 row.
Then copy formula from these cell to the next cells in column until formula dos not indicate an error.
--------------------
step = 8
=IF(VLOOKUP((ROW()-COUNT(J:J)-(3-1));J:L;2;FALSE())<>"";"SUMIF(C="&VLOOKUP((ROW()-COUNT(J:J)-(3-1));J:L;2;FALSE())&";"&"D"&")=";"")
Copy formula in cell N at the end of table + 1 row.
Then copy formula from these cell to the next cells in column until formula dos not indicate an error.
--------------------
step = 9
=VLOOKUP((ROW()-COUNT(J:J)-(3-1));J:L;3;FALSE())
Copy formula in cell O at the end of table + 1 row.
Then copy formula from these cell to the next cells in column until formula dos not indicate an error.