Results 1 to 6 of 6

merging countif and sumproducts

Threaded View

fontana merging countif and... 12-20-2010, 02:52 PM
NBVC Re: mergine count and... 12-20-2010, 02:59 PM
fontana Re: merging countif and... 12-20-2010, 03:53 PM
NBVC Re: merging countif and... 12-20-2010, 03:59 PM
fontana Re: merging countif and... 12-20-2010, 04:09 PM
NBVC Re: merging countif and... 12-20-2010, 04:12 PM
  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    toronto, canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    merging countif and sumproducts

    Is there any way to merge these two formulas?
    =COUNTIF(Active!$A$2:$A$426,"*construction*")
    =SUMPRODUCT((Active!$G$2:$G$426>=11)*(Active!$G$2:$G$426<=20))
    Last edited by NBVC; 12-20-2010 at 04:56 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