Results 1 to 6 of 6

using countif function for multiple worksheets

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    using countif function for multiple worksheets

    I am trying to use countif to count the number of times a unique items occurs in multiple worksheets.

    For example, I want to count number of times "ITEM1" occurs in row 1 of sheets1, sheets2, sheets3, sheet4, etc. It may look like this:
    Sheet1 = 4 entries
    Sheet2 = 22 entries
    Sheet3 = 5 entries
    Sheet4 = 10 entries

    So the entire count would be 41 total. Thanks.
    Last edited by maacmaac; 01-28-2010 at 03:53 PM.

Thread Information

Users Browsing this Thread

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

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