Thread: Using formulas in conditions (SUMIF, AVERAGEIF)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jan Kucera Jan Kucera is offline
external usenet poster
  
Posts: 7
Default Using formulas in conditions (SUMIF, AVERAGEIF)
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

Reply With QuoteReply With Quote