Cumbersome IF Statement

[Cindi]

I have several cells involved in this IF statement. I've tried to do a
SUMIF, but I can't get it to work. Can someone help me please?

=IF($I$33="No",(+H33*D50))+IF($I$33="Yes",0)+IF($I$34="No",(+H34*D50))+IF($I$34="Yes",0)+IF($I$35="No",(+H35*D50))+IF($I$35="Yes",0)+IF($I$36="No",(+H36*D50))+IF($I$36="Yes",0)+IF($I$37="No",(+H37*D50))+IF($I$37="Yes",0)+IF($I$38="No",(+H38*D50))+IF($I$38="Yes",0)+IF($I$39="No",(+H39*D50))+IF($I$39="Yes",0)+IF($I$40="No",(+H40*D50))+IF($I$40="Yes",0)+IF($I$41="No",(+H41*D50))+IF($I$41="Yes",0)+IF($I$43="No",(+H43*D50))+IF($I$43="Yes",0)+IF($I$56="No",(+H56*D50))+IF($I$56="Yes",0)+IF($I$57="No",(+H57*D50))+IF($I$57="Yes",0)+IF($I$58="No",(+H58*D50))+IF($I$58="Yes",0)

 

[Brad]

=SUMIF(I33:I58,"No",H33:H58)*H50

 

[Cindi]

There's a break between rows 43 & 56 that can't be counted. How do I do that?

 

[Cindi]

I forgot the second part, if it's Yes, then it needs to be zero.

 

[Brad]

The formula will only add up values if the information in Column I is "No".
Anything other than "No" will not be included (including "Yes")

Change the formula to be
=(sumif(i33:i43,"No",H33:H43)+sumif(i56:i58,"No",H56:H58))*50

 

[Cindi]

Thanks for the help!
--
Cindi H

The formula will only add up values if the information in Column I is "No".
Anything other than "No" will not be included (including "Yes")

Change the formula to be
=(sumif(i33:i43,"No",H33:H43)+sumif(i56:i58,"No",H56:H58))*50

 

[Brad]

You're welcoms
--
Wag more, bark less

Thanks for the help!