sumif

J

jiwolf

I am looking to sumif the value in a cell is between 1 and 10. I am ok
with values above 10,

=SUMIF(A1:A100,">10",B1:B100) but I cant get above a certain value and
below another! any help please?


Pete
 
C

carlyman

I keep seeing "--" in sumproduct functions: =SUMPRODUCT(--(A1:A100....

What does the "--" mean/do
 
Top