Results 1 to 4 of 4

Return a range of cells that meets a criteria

Threaded View

bgallagher1 Return a range of cells that... 08-13-2010, 05:34 PM
Richard Buttrey Re: Return a range of cells... 08-13-2010, 06:09 PM
bgallagher1 Re: Return a range of cells... 08-13-2010, 08:47 PM
Richard Buttrey Re: Return a range of cells... 08-14-2010, 04:33 AM
  1. #3
    Registered User
    Join Date
    08-10-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Return a range of cells that meets a criteria

    That very well may be a part of it, but I need the formula to return a range of cells, that is my difficulty --- E3:E19 for example. This range would then go in to a separate formula that would be used to calculate the mode of support case subjects on a per month/quarter/year basis.

    How can I use a countifs to return a range? I use that quite often to count cells that contain certain criteria, but never to return a range.
    Last edited by bgallagher1; 08-13-2010 at 08:49 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