+ Reply to Thread
Results 1 to 6 of 6

how to average a value in blank cells in a column between cells with data

  1. #1
    Registered User
    Join Date
    03-22-2019
    Location
    NYC,USA
    MS-Off Ver
    2016
    Posts
    3

    how to average a value in blank cells in a column between cells with data

    Hello I am stumped as to how to put averages in blank cells between data in a column. For instance i have a column of temperature data that I am trying to correlate with sulfur data and I have blank cells between the cells because the temp data does not have same dates as sulfur data so there are blanks in the temp data. So I am trying to average the temp data to fit in the blank cells.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: how to average a value in blank cells in a column between cells with data

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

  3. #3
    Registered User
    Join Date
    03-22-2019
    Location
    NYC,USA
    MS-Off Ver
    2016
    Posts
    3

    Re: how to average a value in blank cells in a column between cells with data

    Hello Here is a sample of the work book but I dont know how to upload a pdf file here. Word file doesn't work.
    Last edited by mitomke; 03-22-2019 at 03:46 PM.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: how to average a value in blank cells in a column between cells with data

    Click on the Go Advanced Button, then scroll down to find “manage Attachments” Then Browse to find the file, then “Upload” “Close Window” and Post.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    03-22-2019
    Location
    NYC,USA
    MS-Off Ver
    2016
    Posts
    3

    Re: how to average a value in blank cells in a column between cells with data

    Ok I uploaded file but it disappeared from view

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: how to average a value in blank cells in a column between cells with data

    Hello mitomke and Welcome to Excel Forum.
    If I understand correctly then the following may help.
    Column C contains the temperatures that were actually taken. You will not be able to put a formula in C2 and fill down as the formula would overwrite the existing values.
    My proposed work around is to populate column D using: =IF(ISNUMBER(C2),C2,AVERAGE(C1,C3))
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto Average Cells on Either Side of Blank in Column
    By jmjohnston in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2018, 07:34 PM
  2. How to Get the Average of First 5 Non-Blank Cells in a Column?
    By southerk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2014, 10:01 PM
  3. Replies: 14
    Last Post: 03-24-2014, 08:09 PM
  4. Replies: 4
    Last Post: 11-20-2013, 10:16 PM
  5. Average the last 10 cells of a dynamic column but ignore blank cells & 0
    By mattadler22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-13-2013, 11:37 PM
  6. [SOLVED] find blank cells in column and average the cells below
    By desibabuji in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-03-2013, 12:03 PM
  7. Average of next 6 non blank cells in a column.
    By hackboy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-15-2012, 10:44 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1