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

Please Login or Register  to view this content.

oh nice, that looks somewhat neater.

Learn something new every day