HELP required for formula

[Garry8741]

Seeking help to write a formula for the following data
[TABLE="width: 576"]
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl65, width: 64"]Col A[/TD]
[TD="class: xl65, width: 64"]Col B[/TD]
[TD="class: xl65, width: 64"]Col C[/TD]
[TD="class: xl65, width: 64"]Col D[/TD]
[TD="class: xl65, width: 64"]Col E[/TD]
[TD="class: xl65, width: 64"]Col F[/TD]
[TD="class: xl65, width: 64"]Col G[/TD]
[TD="class: xl65, width: 64"]Col H[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 1[/TD]
[TD="class: xl67"]42[/TD]
[TD="class: xl67"]45[/TD]
[TD="class: xl67"]17[/TD]
[TD="class: xl67"]15[/TD]
[TD="class: xl67"]24[/TD]
[TD="class: xl67"]18[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 2[/TD]
[TD="class: xl67"]21[/TD]
[TD="class: xl67"]32[/TD]
[TD="class: xl67"]35[/TD]
[TD="class: xl67"]9[/TD]
[TD="class: xl67"]30[/TD]
[TD="class: xl67"]27[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]1[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 3[/TD]
[TD="class: xl67"]14[/TD]
[TD="class: xl67"]24[/TD]
[TD="class: xl67"]44[/TD]
[TD="class: xl67"]22[/TD]
[TD="class: xl67"]12[/TD]
[TD="class: xl67"]20[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]1[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 4[/TD]
[TD="class: xl67"]33[/TD]
[TD="class: xl67"]25[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl67"]34[/TD]
[TD="class: xl67"]30[/TD]
[TD="class: xl67"]19[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 5[/TD]
[TD="class: xl67"]29[/TD]
[TD="class: xl67"]43[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl67"]13[/TD]
[TD="class: xl67"]32[/TD]
[TD="class: xl67"]1[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 6[/TD]
[TD="class: xl67"]19[/TD]
[TD="class: xl67"]18[/TD]
[TD="class: xl67"]6[/TD]
[TD="class: xl67"]10[/TD]
[TD="class: xl67"]32[/TD]
[TD="class: xl67"]36[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 7[/TD]
[TD="class: xl67"]24[/TD]
[TD="class: xl67"]11[/TD]
[TD="class: xl67"]22[/TD]
[TD="class: xl67"]26[/TD]
[TD="class: xl67"]33[/TD]
[TD="class: xl67"]18[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]1[/TD]
[/TR]
[TR]
[TD="class: xl66"]Row 8[/TD]
[TD="class: xl67"]25[/TD]
[TD="class: xl67"]44[/TD]
[TD="class: xl67"]41[/TD]
[TD="class: xl67"]1[/TD]
[TD="class: xl67"]11[/TD]
[TD="class: xl67"]22[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]1[/TD]
[/TR]
</tbody>[/TABLE]

for the block A1:F8
count the number of times the number "1" occurs
IF the Row is "0" (zero) in Column H

Thank you, Garry

 

[NiMip]

Try =SUM(--((A1:F8*(H1:H8=0))=1)) and hit CONTROL+SHIFT+ENTER rather than just enter, as it's an array formula.

 

[Dim Me as xlNoob]

Do you want a count of how many times the value 1 occurs in the row only when column H = 0? You can copy this formula down:

=IF($H1=0, COUNTIF($A1:$F1,"=1"),0)

This will say "0" unless H=0 and there are 1's in that row.

EDIT: I misread the question.

 

[Aladin Akyurek]

If you don't want to read an empty cell in H1:H8 as 0, control+shift+enter, not just enter:

=SUM(IF(ISNUMBER(H1:H8),IF(H1:H8=0,(A1:F8=1)+0)))

 

[Garry8741]

Thanks for your assistance - formulas worked fine