RE: Average a group of numbers within an date range.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Your formula is fine, it's the way you are entering it, it's an array

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike

"sross" wrote:

I have a spreadsheet that has tickets for an entire year. I have calculated
a field that has the total number of days a ticket was open for each ticket.
I am trying to average the total number of days a ticket is open by month,
to have an average number of days a ticket is open per month. I have tried
this calculation but am not getting a valid number. My dates are in
month/day/year format. 01/01/09. Thanks for your help

=IF(B2=0,0,(AVERAGE(IF((MONTH(Data!$O$3:$O$4834)=1)*(YEAR(Data!$O$3:$O$4834)=2009),(Data!$AT$3:$AT$4834)))))
.

Relevant Pages

  • Re: Average a group of numbers within an date range.
    ... Did you enter it as an array? ... Microsoft Excel MVP ... a field that has the total number of days a ticket was open for each ... this calculation but am not getting a valid number. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Numeric one-way hash function
    ... >> create a unique barcode on a ticket that cannot be predicted. ... Using the original decimal digit as an offset into the array, ... You did not specify how the array should be shuffled. ...
    (sci.crypt)
  • RE: Average a group of numbers within an date range.
    ... "Mike H" wrote: ... Your formula is fine, it's the way you are entering it, it's an array ... This is an array formula which must be entered with CTRL+Shift+Enter and NOT ... a field that has the total number of days a ticket was open for each ticket. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Function for combinations
    ... combinations and use its index for the identifier. ... Using an array index will always give you a unique ID. ... I use zero based because my wheeling combos are stored in ranges where the first cell is the wheel config, which always occupies arrayso ticket numbering starts at arrayon up to the UBound. ...
    (microsoft.public.excel.programming)
  • Re: php nesting classes
    ... In the Order object I store an array with Ticket objects. ... And since the Order object itself has Ticket objects, perhaps the you need an Order::MakeTicket method to create the Ticket object and fill in the information (including a reference to itself). ...
    (comp.lang.php)