+ Reply to Thread
Results 1 to 5 of 5

Simple Counts from a different sheet

Hybrid View

  1. 02-13-2022, 08:26 PM #1
    badmullah
    badmullah is offline
    Registered User
    Join Date
    02-04-2021
    Location
    Australlia
    MS-Off Ver
    365
    Posts
    48

    Simple Counts from a different sheet

    Sheet 1 has some records
    with one of the Fields STATUS having values such as "One , TWO , THREE,..."


    In sheet 2 I like to have
    a tabulated table listing the counts from sheet 1

    VALUE1 : a formula , macro ,query ,.... that would select the count of how many records were found with STATUS ="ONE" from sheet 1.
    VALUE1 : a formula , macro ,query ,.... that would select the count of how many records were found with STATUS ="ONE" from sheet 1.


    This should be very easy I believe who works with Excel

    Thanks for your help
    Reply With QuoteRegister To Reply
  2. 02-13-2022, 08:51 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Simple Counts from a different sheet

    This formula will count every cell in Sheet1 column A with the word "ONE". It is not case sensitive.

    Formula: copy to clipboard 
    =COUNTIF(Sheet1!A:A, "ONE")
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 02-13-2022, 08:56 PM #3
    badmullah
    badmullah is offline
    Registered User
    Join Date
    02-04-2021
    Location
    Australlia
    MS-Off Ver
    365
    Posts
    48
    Quote Originally Posted by AlphaFrog View Post
    This formula will count every cell in Sheet1 column A with the word "ONE". It is not case sensitive.

    Formula: copy to clipboard 
    =COUNTIF(Sheet1!A:A, "ONE")

    2- what if there is a second condition such as VALUE of DATE ="02/02/22"

    Thanks
    Last edited by badmullah; 02-13-2022 at 09:29 PM.
    Reply With QuoteRegister To Reply
  4. 02-13-2022, 09:09 PM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Simple Counts from a different sheet

    Change the A:A to the column letter the Status column is in.
    Reply With QuoteRegister To Reply
  5. 02-15-2022, 07:13 PM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,972

    Re: Simple Counts from a different sheet

    The query about a second condition has been asked and answered here: https://www.excelforum.com/excel-for...onditions.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Subtracting one sum of counts from another sum of counts in a pivot table
    By steve78 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-07-2019, 01:35 PM
  2. Kpi's sheet that Auto counts from weeks to monthly but also sorts highest to lowest
    By Nulvoid08 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-17-2018, 02:53 AM
  3. VBA code that counts the number of entries in a textbox from a different sheet?
    By danbates in forum Excel General
    Replies: 1
    Last Post: 01-23-2018, 06:05 AM
  4. Macro which counts the number of cells in sheet 1& in sheet 2 this exact number is pasted
    By Soneeka in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-08-2015, 12:30 PM
  5. I need a formula the counts the number of cells that meet 2 conditions ac multiple w/sheet
    By clemmy75 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 01:43 PM
  6. combine counts from multiple sheets to one sheet
    By flyguyph in forum Excel General
    Replies: 2
    Last Post: 12-13-2010, 04:08 PM
  7. How do I build a excel sheet that counts item in an inventory
    By kenny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2006, 11:10 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1