+ Reply to Thread
Results 1 to 5 of 5

formula to get Count

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    formula to get Count

    Hello:

    Please refer to attached file.
    I need formula in cell B3 down to give result as 4,6,7,6......
    I have highlighted the total entries for each date in column H,L,P, T
    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,366

    Re: formula to get Count

    Put on B3 and copied down

    =SUMPRODUCT((($G$3:$G$33=$A3)+($K$3:$K$33=$A3)+($O$3:$O$33=$A3)+($S$3:$S$33=$A3)>0)+0)
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: formula to get Count

    Hello azumi:

    Thanks a lot for help, however this will be for lots of date (31 days)and the above formula will be huge.
    Would there be easy way.
    Please let me know if you have any questions.
    Thanks.

    Riz

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: formula to get Count

    Hi Riz,

    Enter this array formula in B3 and copy down

    **Must be entered with Ctrl+Shift+Enter key combination.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    what was I thinking... it could be much easier with this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by AlKey; 07-25-2017 at 08:44 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: formula to get Count

    Hi Alkey:

    Thanks a lot, makes my life easyyyyyyyyy

    Riz

+ 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. Count if formula to count absent days
    By salsi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2017, 02:07 AM
  2. (Count Formula) Count if two seperate ranges create unique combination
    By Geekcrux in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2016, 07:00 AM
  3. Formula to count number of visible rows, and formula to count visible blanks
    By radoncadonc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2015, 04:19 PM
  4. [SOLVED] Count formula not count hidden cells in table
    By tlacloche in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2013, 02:35 PM
  5. [SOLVED] Count and average formula needed to not count text field
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2013, 05:30 PM
  6. [SOLVED] Count/No Count for year entered---formula help
    By awest181 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2012, 02:07 PM
  7. Replies: 5
    Last Post: 08-29-2012, 05:25 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