HELP required for formula

[Garry8741]

Seeking help to write a formula for the following data

	Col A	Col B	Col C	Col D	Col E	Col F	Col G	Col H
Row 1	42	45	17	15	24	18		0
Row 2	21	32	35	9	30	27		1
Row 3	14	24	44	22	12	20		1
Row 4	33	25	5	34	30	19		0
Row 5	29	43	5	13	32	1		0
Row 6	19	18	6	10	32	36		0
Row 7	24	11	22	26	33	18		1
Row 8	25	44	41	1	11	22		1

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>

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