Results 1 to 18 of 18

Modification to COUNTIFS formula

Threaded View

rhudgins Modification to COUNTIFS... 06-15-2011, 02:36 PM
Miraun Re: Modification to COUNTIFS... 06-15-2011, 02:41 PM
rhudgins Re: Modification to COUNTIFS... 06-15-2011, 02:43 PM
darkyam Re: Modification to COUNTIFS... 06-15-2011, 02:44 PM
rhudgins Re: Modification to COUNTIFS... 06-15-2011, 02:51 PM
daddylonglegs Re: Modification to COUNTIFS... 06-15-2011, 02:57 PM
darkyam Re: Modification to COUNTIFS... 06-15-2011, 02:58 PM
darkyam Re: Modification to COUNTIFS... 06-15-2011, 03:00 PM
daddylonglegs Re: Modification to COUNTIFS... 06-15-2011, 03:03 PM
rhudgins Re: Modification to COUNTIFS... 06-15-2011, 03:15 PM
daddylonglegs Re: Modification to COUNTIFS... 06-15-2011, 04:09 PM
rhudgins Re: Modification to COUNTIFS... 06-15-2011, 04:15 PM
daddylonglegs Re: Modification to COUNTIFS... 06-15-2011, 04:28 PM
rhudgins Re: Modification to COUNTIFS... 06-15-2011, 04:21 PM
rhudgins Re: Modification to COUNTIFS... 06-15-2011, 04:38 PM
rhudgins Re: Modification to COUNTIFS... 06-16-2011, 10:38 AM
daddylonglegs Re: Modification to COUNTIFS... 06-16-2011, 11:31 AM
rhudgins Re: Modification to COUNTIFS... 06-16-2011, 12:14 PM
  1. 06-15-2011, 02:36 PM #1
    rhudgins is offline
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Modification to COUNTIFS formula

    Is there a way to change this formula so that it will only calculate the COUNTIFS on data that falls in the month of May? The dates in the data set are in the range V14:V100000


    =SUM(COUNTIFS($Q$14:$Q$10000,{"ii1x2","ii1x3","ii1x4","ii1x5","ii1x6","ii1x7","ii1x8","ii1x9","ii1x10"},$K$14:$K$10000,{">0"}))
    Last edited by rhudgins; 06-16-2011 at 12:27 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1