<< Click to Display Table of Contents >> Navigation:  How to > Excel > Excel formulas

vpxPrint connects to Excel through an OLE link.

 

Some restrictions exist, due to Microsoft Excel on some formulas. Microsoft Knowledge base 260415

SUMIF             (SOMME.SI)

Instead of:

                 =SUMIF([source]Sheet1!$A$1:$A$8,"a",[source]Sheet1!$B$1:$B$8)

Use :

                 = SUM (IF ([Source] Sheet1! $A$ 1: $A$8="a",[Source]Sheet1!$B$1:$B$8,0))

COUNTIF        (NB.SI)

Instead of:

                 =COUNTIF([source]Sheet1!$A$1:$A$8,"a")

Use:

                 = SUM (IF ([Source] Sheet1! $A$ 1: $A$ 8 = "a", 1, 0))

COUNTBLANK

Instead of:

                 =COUNTBLANK([source]Sheet1!$A$1:$A$8)

Use:

                 = SUM (IF ([Source] Sheet1! $A$ 1: $A$ 8 = "", 1, 0))