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