+ Reply to Thread
Results 1 to 4 of 4

I want to Tally numbers in 2nd sheet excel

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    I want to Tally numbers in 2nd sheet excel

    Sir,In first sheet state, district, federation names and In 2nd sheet state and district here i want to bring total of state and district numbers in 2nd sheet by using formula. How ? my formula shows wrong. pls send me easy method
    Attached Files Attached Files
    Last edited by maddyrafi1987; 09-22-2018 at 03:31 AM.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: I want to Tally numbers in 2nd sheet excel

    If you wish to check individually check the try below

    I4
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Or if you wish check total then try

    i4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: I want to Tally numbers in 2nd sheet excel

    It working nice and if i copy and paste the same cell formula it was not working in F4 and G4 so I need formula for F4 and G4 also,
    Last edited by maddyrafi1987; 09-22-2018 at 03:42 AM.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: I want to Tally numbers in 2nd sheet excel

    Use below formula for all the cells

    I4
    Formula: copy to clipboard
    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. [SOLVED] How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Years
    By jdrenken7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-26-2017, 10:28 PM
  2. [SOLVED] Find all entries in a range and tally numbers based on codes in adjacent fields
    By reynastus2 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-07-2014, 10:28 PM
  3. Replies: 1
    Last Post: 06-26-2014, 12:01 PM
  4. [SOLVED] Converting numbers into tally marks and calculating them for tracking purposes
    By Gyrlie68 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2014, 05:42 PM
  5. Help With A Tally Sheet
    By JOB Dave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 09:55 PM
  6. How to use Macro in Excel to create a basic tally sheet
    By personette in forum Excel General
    Replies: 3
    Last Post: 09-25-2012, 12:08 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