+ Reply to Thread
Results 1 to 7 of 7

Adding the rows value if one column numbers match

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    24

    Adding the rows value if one column numbers match

    Sir

    Again I need another formula. I hope you help me like last time.



    Musiri4P.xlsx

    As you see extent and total tax in D and E columns respectively.

    Now I need to add those columns rows in G and H respectively only when PATTA NO in A column is same. like put in above screenshot.



    It is tedious and error prone if done manually. So Please device any formula for this.
    Last edited by 10AVATAR; 10-06-2012 at 09:35 AM.

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Adding the rows value if one column numbers match

    use in row 2

    =IF(COUNTIF($A$2:$A2,$A2)>1,"",SUMIF($A$2:$A$1693,$A2,D$2:D$1693))

    Copy down and across

    See attached highlighted
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    24

    Re: Adding the rows value if one column numbers match

    Thanks a Lot Sir! This is very quick!

    Really you are the XL God sir!

    I really want to learn advance XL like you!

  4. #4
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    24

    Re: Adding the rows value if one column numbers match

    Sir

    Now I need a improvement in above formula


    I replaced land type column 'C' like

    W - 1
    D - 0

    Musiri4PT.xlsx


    now in G and H total extent and tax of patta will be calculated if only land type column 'C' value = 1 (that is wet)

    and

    in I and J total extent and tax of patta will be calculated if only land type column 'C' value = 0 (that is dry)

  5. #5
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    24

    Re: Adding the rows value if one column numbers match

    Please Help!

  6. #6
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,186

    Re: Adding the rows value if one column numbers match

    In G2,

    =IF(COUNTIF($A$2:$A2,$A2)=1,SUMIFS(D:D,$A:$A,$A2,$C:$C,1),"")

    then copy to H2.

    In I2,

    =IF(COUNTIF($A$2:$A2,$A2)=1,SUMIFS(D:D,$A:$A,$A2,$C:$C,0),"")

    then copy to J2,

    Finally copy G2:H2, then fill down.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  7. #7
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    24

    Re: Adding the rows value if one column numbers match

    Thanks Sir!

    Works Great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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