Results 1 to 3 of 3

Thread: Sum on Max value in repeated data

  1. #1
    Neophyte sathishmadhav@gmail.com's Avatar
    Join Date
    May 2021
    Posts
    1
    Articles
    0
    Excel Version
    2016 2019

    Sum on Max value in repeated data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All

    Referring the table below, I wish to sum total invoice value on the line where invoice is ending. Each invoice number has line numbers and sum formula should be applicable only on last line/max line of each invoice. Kindly suggest.

    Inv Number Line No Value Sum by Invoice
    316 1 $500
    316 2 $215
    317 1 $452
    317 2 $125
    317 3 $521
    317 4 $124
    318 1 $150

    Thanks
    Sats

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,949
    Articles
    0
    Excel Version
    365
    There are built-in facilities for this sort of thing.
    In the attached Sheet1 there's Outline|Subtotal, see:
    Outline (group) data in a worksheet - Excel
    https://support.microsoft.com/en-us/...7-8278c49e9aff
    Insert subtotals in a list of data in a worksheet - Excel
    https://support.microsoft.com/en-us/...e-b0a3d4a52b3a


    and on Sheet2 you can create a Pivot table in 30 seconds.
    Attached Files Attached Files

  3. #3
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Posts
    52
    Articles
    0
    Excel Version
    365
    Hi

    Assuming your data is in A1:C8, in D2 place the following and copy down.

    =IF(A2<>A3,SUMIF($A$2:$A$8,A2,$C$2:$C$8),"")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •