SUMIF Problem

[Rossco]

Using a sumif statement, I want it to only count numbers
greater than 5 and less than 10 but cant get it to work,
this is the formula im using wat am I doin wrong?

=SUMIF(A1:A16,(AND(">5","<10")),B1:B16)

Thanks

 

[Andy B]

Hi

One way is to use two SUMIFs:
=SUMIF(A1:A16,">5",B1:B16)-SUMIF(A1:A16,",">10",B1:B16)
Another is:
=SUMPRODUCT((A1:A16>5)*(A1:A16<10)*(B1:B16))

 

[Guest]

Thanks Andy u've been a big help!!

-----Original Message-----
Hi

One way is to use two SUMIFs:
=SUMIF(A1:A16,">5",B1:B16)-SUMIF(A1:A16,",">10",B1:B16)
Another is:
=SUMPRODUCT((A1:A16>5)*(A1:A16<10)*(B1:B16))

--
Andy.





.

 

[Andy B]

Thanks for the thanks!

--
Andy.

Thanks Andy u've been a big help!!