+ Reply to Thread
Results 1 to 2 of 2

total count of row in a table in another sheet

  1. #1
    Registered User
    Join Date
    08-12-2015
    Location
    india
    MS-Off Ver
    2010
    Posts
    40

    total count of row in a table in another sheet

    Dear All,

    Pls ref the attched excel. i have furits and its color entered in a row in sheet1, in sheet2, i have fruits as the column heading and colurs in the row. i need the total of each color... and if it zero , can we avoid displaying the zeros

    ref attached sheet with example and extected result
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: total count of row in a table in another sheet

    Put this in B2 then copy right and down as necessary
    =COUNTIFS(Sheet1!$C:$C,$A2,Sheet1!$B:$B,B$1)

    Custom format the cells as #"" to hide the zeros.

    See attached.

    BSB
    Attached Files Attached Files
    Last edited by BadlySpelledBuoy; 07-14-2019 at 02:32 PM.

+ 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 number of instances from once sheet and add total in another cell on other sheet
    By Interst3llar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2018, 04:21 AM
  2. Filter data from every sheet to find total count
    By bananacitizen in forum Excel General
    Replies: 6
    Last Post: 07-04-2018, 06:44 AM
  3. [SOLVED] Formula for running total (static count) of repeated values in a table
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-22-2017, 03:17 PM
  4. Pivot Table - Determining Total Count
    By chicity26 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-26-2017, 07:40 PM
  5. pivoting total count of multiple columns from a table
    By kor123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-26-2016, 01:11 AM
  6. Replies: 3
    Last Post: 05-08-2013, 07:25 AM
  7. Excel 2007 : Count total quantity in a table
    By SEHRA in forum Excel General
    Replies: 2
    Last Post: 05-30-2011, 04:55 AM

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