+ 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
    173

    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
    2016
    Posts
    3,681

    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
    173

    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
    2016
    Posts
    3,681

    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)

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