• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Item Name repeted when rate of tax, uom or hsn code changes

madhusudhana

New Member
dear sir
the same item name gets repeated when the rate of tax, hsn,uom changed and need a report with formulas
 

Attachments

  • Q1.xlsx
    10.1 KB · Views: 3
SUMIFS would do the job
= SUMIFS( data[Total], data[ITEM NAME], [@[ITEM NAME]], data[UOM], [@UOM] )
With dynamic arrays that becomes a single formula
= SUMIFS(data[Total], data[ITEM NAME], ITEM_NAME, data[UOM], UOM )
where the ranges ITEM_NAME and UOM are created by the formula
= UNIQUE( data[[ITEM NAME]:[UOM]] )
 
Back
Top