+ Reply to Thread
Results 1 to 5 of 5

Countifs and sumifs using Name Range

  1. #1
    Registered User
    Join Date
    02-11-2015
    Location
    U.S
    MS-Off Ver
    2010
    Posts
    23

    Countifs and sumifs using Name Range

    how do i make countifs and sumifs function/formula to count and sum everything on Name range.

    any suggestion or advise

    thank you

    =COUNTIFS($A:$A,G3,$D:$D,Docs)

    =SUMIFS($C:$C,$A:$A,Docs)
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Countifs and sumifs using Name Range

    try with CSE (control+shift+enter)

    and second formula:
    =SUMIFS($C:$C,$A:$A,G3,$D:$D,Docs)
    with CSE
    Last edited by sandy666; 04-21-2015 at 11:20 PM.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,700

    Re: Countifs and sumifs using Name Range

    First have you tried cleaning your data (column A) and lookup references in G3:G16? Some of them have trailing space(s) while others do not. Check out "Jonathan" for example.

    I haven't checked the rest......but where there is one....

    After you do try this formula in H3 and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then try this in I3 and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 04-21-2015 at 11:46 PM.

  4. #4
    Registered User
    Join Date
    02-11-2015
    Location
    U.S
    MS-Off Ver
    2010
    Posts
    23

    Re: Countifs and sumifs using Name Range

    it work
    thank you

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,700

    Re: Countifs and sumifs using Name Range

    You're welcome. Glad it works. and thanks for the rep. and thanks for marking the thread [SOLVED]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countifs or Sumifs
    By RalstonT14612 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 11-30-2014, 02:02 PM
  2. [SOLVED] I can countifs a range but not sumifs
    By port in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2014, 07:06 PM
  3. Countifs and Sumifs VBA code with criterias between 2 date range
    By Jul Stev in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2013, 07:08 AM
  4. Sumifs/Countifs with multiple and's and or's
    By falcontrainer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2013, 01:26 PM
  5. Sumifs and countifs
    By JohnGault82 in forum Excel General
    Replies: 3
    Last Post: 02-03-2011, 05:31 PM

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