Don't you consider the expressions in the Sumproduct formula as a sort of
combination?<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jan Kucera" wrote in message
...
Hi Ragdyer,
well, although this is nice math trick, is it impossible to combine
expressions?

Jan


"Ragdyer" wrote in message
...
Forgot a dbl quotes:

=Sumif(A1:A10,"10")-Sumif(A1:A10,"=20")

--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Ragdyer" wrote in message
...
For your <<< SUMIF(A1:A10;"10 AND <20")

Try:
=Sumif(A1:A10,"10")-Sumif(A1:A10,"=20)

OR

=SUMPRODUCT((A1:A1010)*(A1:A10<20)*A1:A10)

--
HTH,

RD


-------------------------------------------------------------------------
-
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

-------------------------------------------------------------------------
-
-

"Jan Kucera" wrote in message
...
Hi,
I want to use formula in condition syntax, but I don't know how to
reference the value being tested.

Like:
SUMIF(A1:A10;"10 AND <20")

Or:
AVERAGEIF(A1:A10;"ISODD(...)")

Thanks for any ideas.

Jan