SUMIF to include several conditions?

Is it possible to use SUMIF to allow multiple conditions? i.e. SUMIF based on criteria of >=800000 and <900000.

I have a feeling it'll be a sumproduct, right?


edit: ok it's sumproduct by the looks of it

You can also use the sum(if function

=SUM(IF((A7:A9>=800000)*(A7:A9<900000),A7:A9))

oh nice, that looks somewhat neater.

Learn something new every day