Someone else mentioned pivot tables, which may indeed be the best way to go; but they are a bit complex. Alternatively, you may want to use the "vlookup" function. This would involve simply adding a new column "Category" into which you would add a code (e.g., "1", "A", Lumber", etc. or whatever you want) and then vlookup would look for the match and sum for each match respective to the indicated column amount. Note that your cvlookup function is imbedded within a sum function to do this. Also, so long as each of your line item descriptions are consistent you do not need to add a category column but, rather, could just "vlookup" on that.
HTH, Richard -----Original Message----- From: Jfw [mailto:[email protected]] On Behalf Of Greg Nickel via Jfw Sent: Sunday, November 30, 2014 8:07 PM To: [email protected] Subject: Catagory grouping in excel Hello all. Can anyone tell me how to group line items in excel by their row title? I have catagories of construction costs that have been expensed on different dates for different amounts. I'd like to categorize them by row title so that all the expenses for each category are grouped together. Thanks, as always. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201411 30/cec9d7a3/attachment.html> _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
