Thread: SUMIF between 2 amounts, eg 51>x> -51
View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default
"Frank Kabel" wrote...
....
or try
=SUMRODUCT(--(D1:D100-50),--(D1:D100<50),C1:C100)

More compact,

=SUMPRODUCT(--(ABS(D1:D100)<50),C1:C100)


Reply With QuoteReply With Quote