How do I use Sumif and have the criteria be >10 AND <26?

[Jose]

I have seen some sumproduct solutions, but unfortunately, I did not write
them down.

 

[Peo Sjoblom]

=SUMIF(A1:A50,">10")-SUMIF(A1:A50,">=26")

or

=SUMPRODUCT(--(A1:A50>10),--(A1:A50<26),A1:A50)




the first formula is more efficient
--


Regards,


Peo Sjoblom

 

[Jose]

THANK YOU!!!!