Greater and Less then

[peanut12341234]

=SUMPRODUCT(($B$5:$K$10>D12)* ($B$5:$K$10<?XML:NAMESPACE PREFIX = F12))<?xml /><F12))<?xml:namespace ns="urn:schemas-microsoft-comfficeffice" prefix="o"></F12))<?xml:namespace><?xml:namespace prefix = o /><o></o>
Gives the total cell count<o></o>
What im looking for is a total amount of the cells that are greater or less then D12 and F12…<o></o>
<o></o>
Can you help?<o></o>
<o></o>
Thanks<o></o>
<o></o>

 

[AlphaFrog]

Try something like this.
=SUMPRODUCT(($B$5:$K$10 > D12)*($B$5:$K$10 < F12)*($B$5:$K$10))

Forum tip: put a space after the > and < signs so the forum editor doesn't interpret them as HTML code.


If you have Excel 2007 or later, you could use SUMIFS instead.
=SUMIFS($B$5:$K$10, $B$5:$K$10,">"&D12, $B$5:$K$10,"<"&F12)

 

[p45cal]

I think you're struggling with this site's treatment of < (and > ?) symbols, try putting the formula in code tags, and I found it helps not to put a formula as the very first thing in a message, and you could try adding a space either side of such symbols.

A guess at your question; try using the + sign instead of multiplying to get the OR function.