Results 1 to 20 of 20

Countifs and sumproduct with two criteria

Threaded View

jewellove Countifs and sumproduct with... 10-26-2012, 09:48 PM
benishiryo Re: Countifs and sumproduct... 10-26-2012, 10:18 PM
jewellove Re: Countifs and sumproduct... 10-26-2012, 10:27 PM
jewellove Re: Countifs and sumproduct... 10-26-2012, 10:36 PM
vlady Re: Countifs and sumproduct... 10-26-2012, 11:20 PM
jewellove Re: Countifs and sumproduct... 10-26-2012, 11:25 PM
Teethless mama Re: Countifs and sumproduct... 10-27-2012, 12:06 AM
jewellove Re: Countifs and sumproduct... 10-27-2012, 03:19 AM
galvinpaddy Re: Countifs and sumproduct... 10-27-2012, 05:44 AM
galvinpaddy Re: Countifs and sumproduct... 10-27-2012, 05:39 AM
jewellove Re: Countifs and sumproduct... 10-27-2012, 05:50 AM
jewellove Re: Countifs and sumproduct... 10-27-2012, 05:56 AM
jewellove Re: Countifs and sumproduct... 10-27-2012, 05:51 AM
galvinpaddy Re: Countifs and sumproduct... 10-27-2012, 06:22 AM
jewellove Re: Countifs and sumproduct... 10-27-2012, 08:20 AM
galvinpaddy Re: Countifs and sumproduct... 10-27-2012, 06:06 AM
jewellove Re: Countifs and sumproduct... 10-27-2012, 08:16 AM
galvinpaddy Re: Countifs and sumproduct... 10-27-2012, 09:16 AM
galvinpaddy Re: Countifs and sumproduct... 10-27-2012, 10:01 AM
vlady Re: Countifs and sumproduct... 10-28-2012, 08:07 PM
  1. #9
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    876

    Re: Countifs and sumproduct with two criteria

    And the same can be said for your formula not displaying the correct result, In C4 the formula should read -
    =COUNTIFS(C11:C302,">=25",C11:C302,"<=49.99")
    and in C5 the formula should read
    =COUNTIFS(C11:C302,">50",C11:C302,"<=74.99")
    Last edited by galvinpaddy; 10-27-2012 at 05:46 AM.

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