+ Reply to Thread
Results 1 to 4 of 4

Need help with counting cells

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    5

    Need help with counting cells

    Newbie
    Can someone plz help this lost soul. Please see attached. What I need or trying to do is get information from b11,b50 and have a total in b5. the columns are filtered with column B having multiple data.
    When column B is filtered with only BKS or SLC or MCP, B5 would count what is visible.
    Another option if possible (preferred), B5 count any visible items in column B. Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Need help with counting cells

    Try

    =SUBTOTAL(103,$B$11:$B$51)

  3. #3
    Registered User
    Join Date
    09-03-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    5

    Re: Need help with counting cells

    Awesome, thanks for the help

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Need help with counting cells

    You're welcome.

+ 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. Replies: 4
    Last Post: 06-13-2014, 07:08 PM
  2. [SOLVED] Counting cells in a column to add formulas to that equal number of cells
    By flipjarg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 11:45 AM
  3. Replies: 0
    Last Post: 05-08-2012, 12:42 PM
  4. Replies: 3
    Last Post: 03-01-2012, 06:17 AM
  5. Counting the non-null cells in a range with noncontinguous cells in a round-robin
    By StudentTeacher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2011, 07:28 AM
  6. Counting congruent cells and noncongruent cells with the same background color.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2009, 05:52 PM
  7. counting cells with data without counting duplicates
    By labettis in forum Excel General
    Replies: 2
    Last Post: 11-05-2007, 12:10 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