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 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 <[email protected]>,
"jiwolf" <[email protected]> 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:A100>10),--(A1:A100<20),B1:B1:B100)
--
HTH
Bob Phillips
"jiwolf" <[email protected]> wrote in message
news:[email protected]...
> 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?
Have a look at the following link...Originally Posted by carlyman
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
Hope this helps!
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH
Bob Phillips
"carlyman" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks