+ Reply to Thread
Results 1 to 11 of 11

Complex addition : different activities on different dates adding to total.

  1. #1
    Registered User
    Join Date
    06-05-2020
    Location
    UK
    MS-Off Ver
    Any
    Posts
    13

    Complex addition : different activities on different dates adding to total.

    Dear Excel genius people,

    Thanks in advance once again as I need your awesome expertise.

    I have a number of activities (8 in total) each one represented by a letter.
    For each date I have two sessions which one given person will be allocated one activity (letter). So each date has two cells which can be different activities.

    I was wondering if there is a formula that would allow me to input letters in each cell for the dates and give me a total for each activity.

    Example

    Capture.PNG

    Cheers!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Complex addition : different activities on different dates adding to total.

    Please post a sample sheet ( see yellow banner)
    Also try to find an alternative to merged cells which are nothing but trouble

  3. #3
    Registered User
    Join Date
    06-05-2020
    Location
    UK
    MS-Off Ver
    Any
    Posts
    13

    Re: Complex addition : different activities on different dates adding to total.

    Thanks, file uploaded with merged cells removed.

    thanks
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Complex addition : different activities on different dates adding to total.

    Try in B2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Complex addition : different activities on different dates adding to total.

    @Aspone

    Cells B2:C9 are still merged.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  6. #6
    Registered User
    Join Date
    06-05-2020
    Location
    UK
    MS-Off Ver
    Any
    Posts
    13

    Re: Complex addition : different activities on different dates adding to total.

    Hi

    Thanks for your reply.

    Obrigado!

    I have several users and when I tried to adapt the formula to the next one it would count on the first user cells.

    Please see attached the spreadhseet

    Obirgado
    Attached Files Attached Files
    Last edited by Aspone; 08-24-2020 at 04:56 AM.

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Complex addition : different activities on different dates adding to total.

    Finally, does the #4 work for you?
    Quang PT

  8. #8
    Registered User
    Join Date
    06-05-2020
    Location
    UK
    MS-Off Ver
    Any
    Posts
    13

    Re: Complex addition : different activities on different dates adding to total.

    Yes, it does. But I could not adjust the formula to other users.

    Cheers

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Complex addition : different activities on different dates adding to total.

    In #6 you have a blanc sheets.

    If there is no data in your file, the result will be blanc.

  10. #10
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Complex addition : different activities on different dates adding to total.

    This formula will update counts from respective range in rows 12 and down.
    Paste in B2 and copy across and down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Take care.

  11. #11
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Complex addition : different activities on different dates adding to total.

    Release the $ sign then copy to column D?

    =COUNTIF(B$12:C$356,LEFT($A2,1))

+ 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. Count If Between Certain Dates and Activities
    By mrsdeapsleap in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2017, 12:20 AM
  2. [SOLVED] Adding up total using dates
    By am760 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-30-2015, 03:40 AM
  3. [SOLVED] Adding cells to a running total on certain dates?
    By will1565 in forum Excel General
    Replies: 8
    Last Post: 07-23-2015, 01:56 AM
  4. Complex number sorting and addition, variable string lengths.
    By comp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2014, 03:39 AM
  5. Paste link function and formula for adding up dates as a total number
    By regional1500 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2013, 11:57 PM
  6. Replies: 1
    Last Post: 09-22-2010, 01:57 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