1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

count unique values across multiple sheets

Discussion in 'Business Applications' started by roninn75, Feb 25, 2014.

Thread Status:
Not open for further replies.
  1. roninn75

    roninn75 Thread Starter

    Joined:
    Feb 19, 2012
    Messages:
    38
    good day

    i wish to count how many times a specific value occur on a specific date across different sheets. i am attaching a sample workbook.

    in the workbook, the dates are extracted from the various sheets and added in cells C3:L3 (or as many dates there are)
    B4:B are constants that will remain there and the values that needs to be found and counted
    the values being counted are always in column F in the different sheets.

    either code or a formula would work, pivot tables not ideal.

    your assistance is highly appreciated
     

    Attached Files:

  2. roninn75

    roninn75 Thread Starter

    Joined:
    Feb 19, 2012
    Messages:
    38
    answer at this link here...
     
  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi Ricardo,
    I saw that the answer was provided in the link you added.
    You should mark this one solved.
    Cheers :)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1120731

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice