Results 1 to 3 of 3

Standard Deviation Function with Time Constraints

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Standard Deviation Function with Time Constraints

    I think this should be a relatively simple one...

    I am trying to create a rolling 2-year standard deviation formula in cell K12 in which the function will run =STDEV(IF(Y76:Y267<>0,Y76:Y267))*SQRT(12) but will only include data that is in the last 24 months. The dates are in B76:B267 and the data is in Y76::Y267.

    I assume I can use the today function in the logic which I have in cell W5 to tell the formula when to begin.... Does anyone know how to do this?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1