sumif
 

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

Try...

=SUMIF(A1:A100,"=1",B1:B100)-SUMIF(A1:A100,"10",B1:B100)

Hope this helps!

In article ,
"jiwolf" wrote:

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

=SUMPRODUCT(--(A1:A10010),--(A1:A100<20),B1:B1:B100)

--
HTH

Bob Phillips

"jiwolf" wrote in message
...
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

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

What does the "--" mean/do?


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=379110

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

What does the "--" mean/do?

Have a look at the following link...

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=379110

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
HTH

Bob Phillips

"carlyman" wrote in
message ...

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

What does the "--" mean/do?


--
carlyman
------------------------------------------------------------------------
carlyman's Profile:
http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=379110