I need a formula, sumif?

[Harvey Waxman]

Reposting because I might have mucked up my earlier request.

I'd like to get the sum of values in column G where the values are less
than M12, equal or more than M11, and where the corresponding entry in
column I equals 'sale'.

I tried this but with no success:

=SUM(IF(($G$29:$G$1000<M12)*($G$29:$G$1000>=M11)*($I$29:$I$1000="sale"),
$G$29:$G$1000))

I hope this doesn't violate protocol.

Thanks

 

[Harvey Waxman]

I was wrong. It works as is. I will voluntarily ban myself for at
least a week for wasting your time :-(