+ Reply to Thread
Results 1 to 4 of 4

Start counting from a name

  1. #1
    Registered User
    Join Date
    07-06-2018
    Location
    Swansea
    MS-Off Ver
    2007
    Posts
    2

    Start counting from a name

    This is my first post so hopefully I cover everything. I have searched but it is a convoluted scenario.

    I have a list of data that is for emails sent to clients. It is separated down the page by name of the sender and everything under that name is what they have sent.

    The info is copied in from an external source so it will change daily.

    I have already created a formula that calculates what the team has sent each day but now I want to break it down by what each person sent each day.

    Is this possible?

    Thanks

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Start counting from a name

    Yes, but sample workbook will be required
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

  3. #3
    Registered User
    Join Date
    07-06-2018
    Location
    Swansea
    MS-Off Ver
    2007
    Posts
    2
    Hi
    Thanks for your quick reply. Here's a sample of the data and format I will have
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Start counting from a name

    I couldn't do this without the help of a Macro, so if you're ok with that this code will help update your data and you can then use the CountIF formula I've added to get the totals

    Please Login or Register  to view this content.

+ 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. formula start and stop counting
    By MM80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2016, 05:37 AM
  2. need formula to start counting plus 450
    By mjcloward in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2013, 04:26 PM
  3. [SOLVED] start counting if date is not in past
    By Megatronixs in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2013, 05:44 PM
  4. Counting with zero between it and start over if..
    By keis386 in forum Excel General
    Replies: 4
    Last Post: 04-15-2011, 09:42 AM
  5. Counting until a condition and then, again counting from start
    By amitraiforyou in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2010, 05:25 PM
  6. How to start counting the hours in a month
    By kdraper in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2007, 06:25 PM
  7. Counting by combined start and end time
    By monger in forum Excel General
    Replies: 2
    Last Post: 02-10-2006, 09:23 PM

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