PDA

View Full Version : Sleeper: Sum rows based on column criteria



canada_user
03-04-2009, 03:48 PM
Hi,

I'm trying to write a macro that will total rows if the value in column A is the same (see attached - the top table is the raw dat, the table below it is how I'd like it to look). I know I can use a pivot or the subtotal function but a macro is since I'd like the data to be formatted as in a spreadsheet.

Thanks in advance.

mdmackillop
03-04-2009, 04:19 PM
Welcome to VBAX
Why not use SumIf?