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]

This might work, I'm not even going to attempt to work out what that formula is meant to be doing.

=SUMPRODUCT((ISNUMBER(1/Sheet!E:E))*(NOT(ISFORMULA(Sheet!E:E)))+(ISNUMBER(1/Sheet!G:G))*(NOT(ISFORMULA(Sheet!G:G))))
-SUMPRODUCT((ISNUMBER(1/Sheet!E:E))*(NOT(ISFORMULA(Sheet!E:E)))*(ISNUMBER(1/Sheet!G:G))*(NOT(ISFORMULA(Sheet!G:G))))
+SUMPRODUCT((ISNUMBER(1/Sheet!D:D))*(NOT(ISFORMULA(Sheet!D:D)))+(ISNUMBER(1/Sheet!F:F))*(NOT(ISFORMULA(Sheet!F:F))))
-SUMPRODUCT((ISNUMBER(1/Sheet!D:D))*(NOT(ISFORMULA(Sheet!D:D)))*(ISNUMBER(1/Sheet!F:F))*(NOT(ISFORMULA(Sheet!F:F))))

 

[Unexpc]

This might work

Yes actually work

I'm not even going to attempt to work out what that formula is meant to be doing

This formula for count value from a row that not count specific cells (in this formula not count same fill cells with in column D and F, E and G)

 

[Unexpc]

but for now i want a formula that count one thing in same row that fill in Column A,B,C

 

[jasonb75]

but for now i want a formula that count one thing in same row that fill in Column A,B,C

I'm lost, is that clarifying the previous formula, or asking a new question? If it is a new one then a better explanation is going to be needed.

 

[Unexpc]

a new question? If it is a new one then a better explanation is going to be needed.

previous is worked, but i found out for now not useful for me, i ask a new question, if it don't need a post thread, i want a formula that count one when in a row filled Column A and B and C, for example in Row 3, fill A3,B3,C3 count this 3 cell as 1
better say, Count every rows that filled one of cell belong Column A,B,C
if you want i post thread and ask this again and write the link in this post that if you want answer this

 

[jasonb75]

Filled with what? An example of the sheet would be more useful than vague descriptions.

COUNTIFS would be the easiest way but how well it would work depends on many other things. Text and numbers have to be counted in different ways, as do blank cells with formulas in them (especially if they have to be excluded).

 

[Unexpc]

Filled with what?

Text

as do blank cells with formulas in them (especially if they have to be excluded).

please see the photo

 

[jasonb75]

Easy enough

=COUNTIFS(A:A,"?*",B:B,"?*",C:C,"?*")

 

[Unexpc]

Easy enough

=COUNTIFS(A:A,"?*",B:B,"?*",C:C,"?*")

Great!
and just two question
1. how to ignore just first two rows? my range that i use after Row 3 (how to ignore Row 1 & 2)?
2. if i use just number for this, what should i change in formula?