<div>
Do you require a VBA solution? &nbsp;Because, if not, i think a pivot table should work for you. &nbsp;If you require help with using a pivot table, let me know and I will give you more detailed instructions.
</div>


Do you require a VBA solution?  Because, if not, i think a pivot table should work for you.  If you require help with using a pivot table, let me know and I will give you more detailed instructions.

<div>
Hi Jim,<br />
I just ran through an audit of some sample data and it looks like you killed it. &nbsp;It did exactly what I wanted and looking through your code I think I will be able to use it to help in with future projects. &nbsp;Thanks 
</div>


Hi Jim,
I just ran through an audit of some sample data and it looks like you killed it.  It did exactly what I wanted and looking through your code I think I will be able to use it to help in with future projects.  Thanks

<div>
Jenckes,<br />
<br />
You're very welcome! &nbsp;Glad to help and thanks for the grade!<br />
<br />
Jim
</div>


Jenckes,

You're very welcome!  Glad to help and thanks for the grade!

Jim

<div>
<div class="content wysiwyg-content">
based on certain matching criteria I am trying to combine rows and sum the contents within certain cells in those rows.<br />
Basically if any rows match with column A, D, and G then combine and sum contents within column F<br />
Column A is the number <br />
Column D is a letter<br />
Column G is a description<br />
<br />
so for all <br />
10, B, Expense<br />
sum the contents of F and reduce to one row<br />
<br />

</div>
</div>


based on certain matching criteria I am trying to combine rows and sum the contents within certain cells in those rows.
Basically if any rows match with column A, D, and G then combine and sum contents within column F
Column A is the number 
Column D is a letter
Column G is a description

so for all 
10, B, Expense
sum the contents of F and reduce to one row



Sum and combine rows based on certain conditions

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.