G Guest Oct 25, 2007 #1 I have seen some sumproduct solutions, but unfortunately, I did not write them down.
P Peo Sjoblom Oct 25, 2007 #2 =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
=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
