PROMOTE YOUR BRAND WITH OUR PROGRAMS
The programs is intended for companis who want to consolidate their brand through free distribution of the programs.
Advertising messages and web links in the programs are tailored to each customer individually.
The advertising message is limited to 10 lines and 500 characters.
Programs promote the customer of the program in three ways:
- with a advertising message at the beginning of the output file;
- with a recurring advertising message in index file;
- and with programmatically generated Google search phrases for each word in the index file and target the customer's site.
More info at:
http://www.utilities4promoting.com
TABLE (EXCEL) FORMULAS GENERATOR SUMIF_01
Program for creating sumif() formulas in MS Excel compatible tables
Program name: sumif_01_083.exe
http://www.utilities4promoting.com/calc-utilities/index.htm
Column name for creating group = B
Column name with data = G
Row number start with data cell = 2
Column name start with free area = i
--------------------
step = 1
=SUMIF(B:B;B2;G:G)
Copy formula in cell I2.
Then copy formula from these cell by the end of the table.
--------------------
step = 2
=COUNTIF(B$2:B2;B2)
Copy formula in cell J2.
Then copy formula from these cell by the end of the table.
--------------------
step = 3
=IF(AND(J2=1;I2<>0);I2;"")
Copy formula in cell K2.
Then copy formula from these cell by the end of the table.
--------------------
step = 4
=COUNT(K$2:K2)
Copy formula in cell L2.
Then copy formula from these cell by the end of the table.
--------------------
step = 5
=B2
Copy formula in cell M2.
Then copy formula from these cell by the end of the table.
--------------------
step = 6
=K2
Copy formula in cell N2.
Then copy formula from these cell by the end of the table.
--------------------
step = 7
=ROW()-COUNT(L:L)-(2-1)
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.
--------------------
step = 8
=IF(VLOOKUP((ROW()-COUNT(L:L)-(2-1));L:N;2;FALSE())<>"";"SUMIF(B="&VLOOKUP((ROW()-COUNT(L:L)-(2-1));L:N;2;FALSE())&";"&"G"&")=";"")
Copy formula in cell P 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(L:L)-(2-1));L:N;3;FALSE())
Copy formula in cell Q 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.