Results 1 to 13 of 13

Calculate the average and standard deviation for every other cell in a column

Threaded View

  1. 04-02-2013, 09:48 PM #1
    wyatt
    wyatt is offline
    Registered User
    Join Date
    04-02-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    10

    Calculate the average and standard deviation for every other cell in a column

    Hello. I need to calculate the average and standard deviation for every other cell in a column (D9:D81). The odd cells contain the data I am interested in. The even cells contain times that I need to ignore. Some of the odd cells will be blank, and I need those to not affect the results of the equation. I have read several posts here and elsewhere that include MOD and ROW functions, but I can't seem to get those to work. Any help would be appreciated.
    Thanks,
    Wyatt
    Last edited by wyatt; 04-02-2013 at 10:33 PM. Reason: More descriptive title
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1