Results 1 to 3 of 3

if averageA function

Threaded View

  1. 08-14-2015, 12:56 PM #1
    WINDSEAKER
    WINDSEAKER is offline
    Registered User
    Join Date
    11-10-2006
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    20

    Lightbulb if averageA function

    Im trying to figure out an average function for data loss in a spreadsheet with a nested if as well.
    Its a common "reset" issue with meters. I have figured out a simple nested if for any "roll-over" known meter values but not a full unpredicted blank "reset" issue.

    Any guidance is welcome.



    Ifaverage function
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble identifying nth instances using *match/index function* with *offset function*
    By donnieboy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  2. Excel 2010 VBA Sheets Copy function works, but then jumps to the beginning of a function
    By mycroft in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  3. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  4. Excel NORM.DIST function gives results greater than 1 with probability mass function. How
    By jano_rajmond in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  5. Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference
    By giallofever in forum Excel General
    Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  6. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM
  7. AVERAGEA Function
    By Chris921 in forum Excel General
    Replies: 2
    Last Post: 03-01-2006, 01:35 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1