How to combine similiar rows

This might be so much easier if you were to post a sample workbook showing your table as is and the desired result.

Sorry for not posting one originally... here you go

Hey so the macro works okay but unfortunately I forgot to put in the sample the possibility of having more than one type of the same spending. The attached workbook makes up for this problem.

The current Macro would combine all lines based off the Type of Spending, not the combination of the two (Type of Spending and Dept). I was thinking maybe a SUMIFS instead of the SUMIF, but unfortunately I am on Office2004 and they don't have the SUMIFS.


2 Questions: If I were to be able to use a Windows machine and the SUMIFS statement on excel 07/10 would the following command work (and then replace the rest of the Range formulas..

2nd: What is a good workaround of SUMIFS for older versions of excel? (Question 1 is more important, I am trying to get the new windows version but it isn't that easy)

Please Login or Register  to view this content.

Here is the original code that I formatted for 10 columns of quarter data

Please Login or Register  to view this content.

Hey, I was able to try the code on my roommates computer and it worked with the addition noted above. Thanks for the help... hopefully we will switch over soon!