Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Averaging Daily Data (2000)

    I have a worksheet with the following: in column A, I have dates beginning with 11/1/1990 in A1, and ending with 10/31/2003. In column B I have daily data corresponding to the day in column A. What I want to do is average all the "November 1st" s in column A in cell C1. I have tried Day(), Month(), and Year() functions, but can't seem to find the correct combination.
    Any help?
    Thanks in advance.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Averaging Daily Data (2000)

    You can modify the response <post#=227888>post 227888</post#> to the nearly identical question you asked starting <post#=227625>post 227625</post#>:

    <hr>Current year average for each date is given by the array formula (ctrl-shift enter to confirm) [all one line]
    =avergae(IF((MONTH(Date)=MONTH($E2))*(DAY(Date)=DA Y($E2))*(YEAR(Date)=YEAR(NOW())),Temperature))<hr>

    To just get the month and day
    =average(IF((MONTH(A1:A5000)=11)*(DAY(a1:a5000)=1) ,C1:C5000))

    Change the range as appropriate.

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Averaging Daily Data (2000)

    Thanks, Steve. I apologize-I ran a search, but evidently overlooked this one. Wow-how do you guys remember all these posts?
    Thanks again.
    Jeff

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Averaging Daily Data (2000)

    I did a search for "steve temperatures" and found the thread

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •