EXCEL - add formula on specific cells during the insert process

**eastydie** · 06-17-2011, 02:05 AM

Hello everybody!

Need help on my macro. I would like insert a row based on a cell and add formula on specific cells.

I have already figured out how to add a row based on a cell -

Please Login or Register  to view this content.

This inserts rows based on the 3rd column (in my attachment, it's the Vegetable column. In my attachment. I have two tabs - one is what the result should be and the other is what the raw/original data looks like.. Basically I need to insert gray rows in every different Vegetable (column C).

I would like to add a formula for sumifs and averageif for column L, M and N. But my ultimate problem is I have no idea how to convert AVERAGEIF formula to a 2003 version. I have worked with COUNT then IF or even COUNTA then IF then use them for my SUM IF but to no avail.. Or even AVERAGE IF but I always have a problem with those data that skip their numbers (ie Amount, Count and Average column as seen on my attachment.)
I have 7000 rows of this to work on so a Macro would come in handy.

Any help is a great help.. Thanks guys!

**watersev** · 06-17-2011, 04:13 AM

hi, eastydie, there is a built-in Excel tool to do large part of it: Subtotal. Takes 2 seconds and several mouse clicks. That's how it looks after without using any macro.