+ Reply to Thread
Results 1 to 2 of 2

Summing Cells in Excel

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Seattle Washington
    MS-Off Ver
    Excel 2003
    Posts
    40

    Summing Cells in Excel

    I have an excel spreadsheet that goes from cell d10 to ai10. Also have 5 possible entries which include: P,A,D,H,J,L which will equal a zero or a one. Only one of these choices will get entered into each cell. I need a function that goes in cell ai that sums number of entries in cells D10 through AH10:

    If entry in any cell from D10 to ah10 = P then 1
    If entry in any cell from d10 to ah10 = A then 1
    If entry in any cell from D10 to ah10 = D then 0
    If entry in any cell from D10 to ah10 = H then 0
    If entry in any cell from D10 to ah10 = J then 0
    If entry in any cell from D10 to ah10 = L then 1. If it happens in 2 cells back to back, then 2. If it happens in more than 2 cells back to back, then 2.

    Any help would be much appreciated.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Summing Cells in Excel

    I need a clarification: Are you only interested in restricting the total of back-to-back L's...or any back-to-back series?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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