+ Reply to Thread
Results 1 to 4 of 4

Simple Tally Formula

  1. #1
    Registered User
    Join Date
    01-22-2020
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    2

    Simple Tally Formula

    Hi, I'm really new at excel and I be this is probably a simple formula, but after reading im going around and around in circles.

    I'll try to put it simply with a pic.

    Each month i run a report. A top 5 tally.

    Column B lists peoples names, sometimes these same people appear several times
    Column C has a tally number next to them

    Basically i want run a report that summarises the names in Column B putting them into Column N and adds up their respective tally number from Column C to their respective numbers in Column O

    Screen Shot 2020-01-22 at 6.39.03 pm.png

    thank you in advance.

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

    Re: Simple Tally Formula

    Hi and welcome
    try the SUMIF function

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Simple Tally Formula

    Or a pivot table with marketer as the row and changes as the value, you can sort by value descending to get the top 5.

  4. #4
    Registered User
    Join Date
    01-22-2020
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    2

    Re: Simple Tally Formula

    Thanks for the welcome. And the tips. I'll read up on those two.
    Half the challenge with excel, for me anyway, is how powerful it is which then creates the task of where to start and look!! LOL.
    I think i can see myself becoming an excel fan/nerd.

+ 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 to tally a certain value IF bold
    By Beh162 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2016, 07:54 PM
  2. Help with SUMPRODUCT formula to tally all values
    By relmasri in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2016, 04:09 PM
  3. Formula/Macro for a Tally in Excel
    By antique in forum Excel General
    Replies: 3
    Last Post: 03-15-2014, 10:25 PM
  4. [SOLVED] Need help with a tally formula
    By alanls1987 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2013, 07:55 AM
  5. formula look up deleting duplicates and tally
    By ellenpost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 10:22 AM
  6. Replies: 5
    Last Post: 08-19-2013, 06:37 PM
  7. create tally sheet for positions- insert names and tally #
    By tally sheets in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 04:45 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