Summing ranges based on two (or more) conditions/criteria

[halvy52]

OK, I have a cell that I need to make a calculation if certain other cells =Y, or to show "0" if the other cells =N. I can do the calculation for the Y part but how do I add the N part of it? Here is what I have:

=SUMIF(J19:J40,"Y",H19:H40)*0.08

Any help would be appreciated. Thanks.

Using Excel 2007