Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Worthington, Ohio, USA
    Thanked 0 Times in 0 Posts

    Averaging rows where data is in every other cell. (Excel 2000)

    I am reposting for anyone else out there that may be able to help on this situation. I am trying to average the number of call made per day. The problem is that I have additional columns with calculations in between each of the days so when I try to average a column, I cannot skip certain cells (in this case, the ones with percentages) and only count others for an average. Also, I want to NOT count those days that do not have anything, or include a "0" which means that that person was not here that day. Any suggestions? I've had one reply but we cannot get the averages to work around (not include or look at ) the columns that include a percentage.

    Please see attachment
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Averaging rows where data is in every other cell. (Excel 2000)

    See my corrections under your original post <post#=202554>post 202554</post#> . Does this do it?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts