Thread: Averaging data if within a date range
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Averaging data if within a date range
"KellyF" wrote:
I've just tried this:
=AVERAGE(IF(TEXT("Offered","mmmyy")="Jun06","TTF") )
in the other worksheet
but it gives 0 as the result (the result is 25).

In formulas, defined ranges are used "as-is" ie without double quotes

Try it like this, array-entered (CSE) as befo
=AVERAGE(IF(TEXT(Offered,"mmmyy")="Jun06",TTF))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote