+ Reply to Thread
Results 1 to 20 of 20

Help with multiple COUNIFS & SUMIFS

Hybrid View

scott79 Help with multiple COUNIFS &... 11-24-2016, 11:41 AM
José Augusto Re: Help with multiple... 11-24-2016, 11:51 AM
scott79 Re: Help with multiple... 11-24-2016, 12:12 PM
José Augusto Re: Help with multiple... 11-24-2016, 02:15 PM
scott79 Re: Help with multiple... 11-24-2016, 02:40 PM
José Augusto Re: Help with multiple... 11-24-2016, 03:05 PM
scott79 Re: Help with multiple... 11-25-2016, 08:03 AM
José Augusto Re: Help with multiple... 11-25-2016, 08:13 AM
scott79 Re: Help with multiple... 11-25-2016, 09:47 AM
scott79 Re: Help with multiple... 11-25-2016, 09:49 AM
José Augusto Re: Help with multiple... 11-25-2016, 10:07 AM
scott79 Re: Help with multiple... 11-25-2016, 10:41 AM
José Augusto Re: Help with multiple... 11-25-2016, 10:50 AM
scott79 Re: Help with multiple... 11-25-2016, 11:01 AM
scott79 Re: Help with multiple... 11-25-2016, 11:07 AM
José Augusto Re: Help with multiple... 11-25-2016, 03:48 PM
scott79 Re: Help with multiple... 11-29-2016, 05:44 AM
José Augusto Re: Help with multiple... 11-29-2016, 06:19 AM
scott79 Re: Help with multiple... 11-29-2016, 11:43 AM
José Augusto Re: Help with multiple... 11-29-2016, 04:23 PM
  1. 11-24-2016, 11:51 AM #1
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Help with multiple COUNIFS & SUMIFS

    Try in F8 and copy down
    Formula: copy to clipboard 
    =IF(E8="x",COUNTIF(D8:D1390,D8),"")
    Reply With QuoteRegister To Reply
  2. 11-24-2016, 12:12 PM #2
    scott79 is offline
    Registered User
    Join Date
    10-27-2016
    Location
    Cambridge, England
    MS-Off Ver
    Microsoft Excel for Mac 15.18
    Posts
    22

    Re: Help with multiple COUNIFS & SUMIFS

    Quote Originally Posted by José Augusto View Post
    Try in F8 and copy down
    Formula: copy to clipboard 
    =IF(E8="x",COUNTIF(D8:D1390,D8),"")
    Thanks Jose, first part fixed!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] COUNIFS exlcuding some texts where it i in Exclusion list 091115-2
    By thilag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-16-2015, 05:58 AM
  2. [SOLVED] COUNIFS exlcuding some texts in vertical columns
    By thilag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2015, 04:20 AM
  3. [SOLVED] SUMIFS,INDEX, MATCH, OFFSET COUNTA / SUMPRODUCT? Multiple criteria across multiple sheets.
    By TheKlaw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2015, 08:44 PM
  4. SUMIFS COUNIFS for just Monday-Friday
    By hc91 in forum Excel General
    Replies: 1
    Last Post: 09-04-2014, 10:28 AM
  5. SUMPRODUCT / SUMIF on multiple sheets, multiple criteria - and without using SUMIFS?
    By ph1rst in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  6. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  7. Counifs then multiply to another column
    By equitalig in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2011, 11:07 AM

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