+ Reply to Thread
Results 1 to 3 of 3

counting and put the result in the other worksheet

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    45

    counting and put the result in the other worksheet

    Dear all,

    anybody can teach me how to do the captioned procedure. i tried to use the pivot table but the result cannot be placed in the second worksheet. Is there any formula can be used ?

    Thanks for your help
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: counting and put the result in the other worksheet

    hi kachuen2006. it's good to let us know what you wish to see too by keying in manually. if you want to sum up both column D & E based on Column C, then:
    =SUMPRODUCT((Log!$C$3:$C$13=C3)*(Log!$D$3:$E$13))

    if it's just column D, then:
    =SUMIF(Log!$C$3:$C$13,C3,Log!$D$3:$D$13)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    08-07-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: counting and put the result in the other worksheet

    Dear Benishiryo, thanks for your knidly help, the formula work fine, but how if i want to calculate the difference between column D and column E base on Column C?

+ 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] Macro to filter active ws in workbook and paste filtered result in "result" worksheet
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2012, 12:01 PM
  2. Counting characters of each cell and printing the result to another worksheet
    By crisshinn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2011, 05:37 AM
  3. Counting cells with formulas-return result
    By garybarrow in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-28-2009, 04:04 PM
  4. Replies: 2
    Last Post: 03-07-2009, 11:44 PM
  5. Counting Duplicates - Displaying Unique Result
    By Gators in forum Excel General
    Replies: 1
    Last Post: 02-13-2009, 05:57 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