+ Reply to Thread
Results 1 to 2 of 2

need excel formula to count the a&b values

  1. 12-24-2015, 09:55 AM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    need excel formula to count the a&b values

    Dear experts

    i have manipulated data which consistent value code and amount

    Code have duplicates towards B:B amount minus/plus values

    i want count the value of minus also like shown below
    HDFC001 1400 2
    HDFC001 -1400 2
    YES0045 4500 1
    YES0045 -8500 1
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 12-24-2015, 11:52 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: need excel formula to count the a&b values

    Trty this...
    A
    B
    C
    D
    1
    		 HDFC001
    1400
    2
    2
    2
    		 HDFC001
    -1400
    2
    2
    3
    		 YES0045
    4500
    1
    1
    4
    		 YES0045
    -8500
    1
    1

    D1=SUMPRODUCT(--($A$1:$A$4=A1),--(ABS($B$1:$B$4)=ABS(B1)))
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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] Formula to count values after other criteria is met
    By hammer2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-02-2014, 12:52 AM
  2. [SOLVED] Count values in one list and then narrow/combine values based on criteria and count those
    By razz0807 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 02:53 PM
  3. Excel formula to find mean value excluding highest and lowest values based on count
    By KJL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2014, 01:55 PM
  4. [SOLVED] excel formula to count the values of week of closed and cancel from data range
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-28-2013, 06:48 AM
  5. [SOLVED] count the values from smallest date with criteria!!! help excel formula
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2013, 11:34 AM
  6. Count formula for different values in same column
    By d.i.y. man in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2013, 05:17 PM
  7. FORMULA to COUNT LOWER 2 OF 3 VALUES
    By timmy5712 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-08-2007, 04:10 AM

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