Results 1 to 3 of 3

Countif multiple ranges, same criteria

Threaded View

ebaldwin Countif multiple ranges, same... 05-14-2012, 09:54 AM
jeffreybrown Re: Countif multiple ranges,... 05-14-2012, 09:58 AM
ebaldwin Re: Countif multiple ranges,... 05-14-2012, 10:18 AM
  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Countif multiple ranges, same criteria

    Please help, I know I am missing something simple in building the formula, but I need to add in two additional ranges in the formula below:

    =COUNTIF(H6:H21,">0")

    I have unsuccessfully tried a variety of tweaks to the formula to get the result I need. A smattering are below for your viewing pleasure:

    =COUNTIF((H6:H21,H23,H33:H36),">0")

    =COUNTIF((H6:H21)+(H23)+(H33:H36),">0")

    =COUNTIF((H6:H21):(H23):(H33:H36),">0")

    I'm sure there is an easy solution available, and I just don't know enough about the proper formula structure to find it, but I am still learning. I would appreciate any help offered!

    Thanks!
    Last edited by ebaldwin; 05-14-2012 at 09:55 AM. Reason: remove emoticons in my formula

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1