Results 1 to 10 of 10

Averaging non consecutive cells

Threaded View

  1. 01-03-2025, 10:20 AM #1
    Paul S Ncube
    Paul S Ncube is offline
    Registered User
    Join Date
    12-13-2024
    Location
    Harare, Zimbabwe
    MS-Off Ver
    office 2016
    Posts
    65

    Averaging non consecutive cells

    I am attempting to get an average of multiple non consecutive cells, ignoring anything that is equal to '0'. The cell distance apart is not fixed and may vary. I have tried this formula SUM(S23,S31,S39,S47,S51)/INDEX(FREQUENCY((S23,S31,S39,S47,S51),0),2) but its returning DIV/0 . May you please help. Thanks
    Last edited by Paul S Ncube; 01-03-2025 at 10:25 AM.
    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. [SOLVED] Help with averaging
    By ReineM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2019, 05:44 PM
  2. Complicated averaging-- averaging data that matches certain intervals
    By atung in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-22-2014, 04:19 PM
  3. Averaging help
    By cmorrison in forum Excel General
    Replies: 1
    Last Post: 08-17-2011, 03:23 PM
  4. Averaging
    By rena in forum Excel General
    Replies: 3
    Last Post: 10-12-2006, 10:52 PM
  5. Help with averaging
    By GTVT06 in forum Excel General
    Replies: 2
    Last Post: 08-15-2006, 09:30 PM
  6. averaging
    By timbrook in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 09:45 AM
  7. Averaging
    By waterwayz in forum Excel General
    Replies: 5
    Last Post: 07-11-2005, 11:05 AM

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