+ Reply to Thread
Results 1 to 5 of 5

to show only one result per date for sumifs formula

Hybrid View

  1. 10-05-2018, 08:47 PM #1
    LFKim2018
    LFKim2018 is offline
    Registered User
    Join Date
    07-20-2018
    Location
    Quezon City, Philippines
    MS-Off Ver
    Excel 2013
    Posts
    84

    to show only one result per date for sumifs formula

    pls see attached file with explanation.
    many thanks..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-05-2018, 09:07 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: to show only one result per date for sumifs formula

    Cell C1
    =IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 10-05-2018, 09:13 PM #3
    LFKim2018
    LFKim2018 is offline
    Registered User
    Join Date
    07-20-2018
    Location
    Quezon City, Philippines
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: to show only one result per date for sumifs formula

    wow!
    fast reply and perfect solution!!
    thank you very very much...
    Reply With QuoteRegister To Reply
  4. 10-05-2018, 09:13 PM #4
    Joske920
    Joske920 is offline
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: to show only one result per date for sumifs formula

    Hi LFKim2018,

    Do you mean the text not visible or the whole row not visible?

    Text could be done with conditional format: cells A2 to C15
    =IF($A2=$A1,1,0)
    Make the color of the text white or the same as background

    The whole row not visible cant be done with a formula for asfar i know

    Grtz
    Reply With QuoteRegister To Reply
  5. 10-05-2018, 09:27 PM #5
    LFKim2018
    LFKim2018 is offline
    Registered User
    Join Date
    07-20-2018
    Location
    Quezon City, Philippines
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: to show only one result per date for sumifs formula

    Mr. Joske920
    thank you for the reply.
    the formula from Mr. AlphaFrog is working just fine.
    many thanks..
    Attached Files Attached Files
    Last edited by LFKim2018; 10-05-2018 at 09:43 PM.
    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. Datediff() to Show Date as Result
    By otuatail in forum Excel General
    Replies: 10
    Last Post: 09-10-2018, 08:22 AM
  2. [SOLVED] Sumifs formula not showing correct result, one of criteria is from pivot table
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2017, 07:59 AM
  3. [SOLVED] SUMIFS Formula not giving desired result
    By lukemelville in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-12-2013, 09:15 AM
  4. [SOLVED] Search in my data base and show result in date categorize
    By pedjvak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 05:04 AM
  5. 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
  6. show text-date as a result of named field formula
    By brum17 in forum Excel General
    Replies: 1
    Last Post: 03-10-2011, 11:51 PM
  7. [SOLVED] Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1