+ Reply to Thread
Results 1 to 1 of 1

Series problem with monthly average

  1. #1
    Registered User
    Join Date
    02-27-2012
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2003
    Posts
    2

    Post Series problem with monthly average

    This is my formula works great except I would like to exclude months that are at zero so the running average isn't so low?
    When I tried adding ">0" it doesn't like that added in to the formula and countif statement it doesn't seem to like it in this series formula.
    =SERIES('2012'!$M$8,('2012'!$N$7:$Y$7,'2012'!$AA$7),('2012'!$N$8:$Y$8,'2012'!$AA$8),1)
    Last edited by ski_jr23; 02-27-2012 at 03:08 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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