ignored zero values count in this formula

[Unexpc]

Hi guys
i have this formula and i want ignored zero values count in this formula :
=SUMPRODUCT((ISNUMBER(Sheet!E:E))*(NOT(ISFORMULA(Sheet!E:E)))+(ISNUMBER(Sheet!G:G))*(NOT(ISFORMULA(Sheet!G:G))))-SUMPRODUCT((ISNUMBER(Sheet!E:E))*(NOT(ISFORMULA(Sheet!E:E)))*(ISNUMBER(Sheet!G:G))*(NOT(ISFORMULA(Sheet!G:G))))+SUMPRODUCT((ISNUMBER(Sheet!D:D))*(NOT(ISFORMULA(Sheet!D:D)))+(ISNUMBER(Sheet!F:F))*(NOT(ISFORMULA(Sheet!F:F))))-SUMPRODUCT((ISNUMBER(Sheet!D:D))*(NOT(ISFORMULA(Sheet!D:D)))*(ISNUMBER(Sheet!F:F))*(NOT(ISFORMULA(Sheet!F:F))))

 

[jasonb75]

1. how to ignore just first two rows? my range that i use after Row 3 (how to ignore Row 1 & 2)?

Change it to use the range you need instead of entire columns.

2. if i use just number for this, what should i change in formula?

Change "?*" to "<>0" although this will not count work if 0 should be counted.

 

[Unexpc]

Change it to use the range you need instead of entire columns.

Change "?*" to "<>0" although this will not count work if 0 should be counted.

Understood, Thank You