Need Macro

[pklimchuk]

Hello Im looking for a Macro,
That would sum all the Totals in Column B for Jan then Feb an so on

and have the Totals Pasted in Column L


Example
Column A Column B
Jan1 $5
jan2 $6
jan3 $3
Feb1 $4
feb2 $5
feb3 $5


Column L
Jan Total $14
Feb Total $14

 

[Zakkaroo]

You can do it without a Macro if you're interested?

A1 = Month (jan, feb, mar etc)
B1 = $$ amount

M1 to M12 = Month that you want to total (Jan, Feb, Mar etc)
L1 = Sum of the Month that is in M1

L1 = SUMIF(A:A,M1&CHAR(42),B:B)

(method borrowed from Aladin - http://www.mrexcel.com/forum/showthread.php?t=25574 )

M1 to M12 can be hidden ... they can be another sheet that you hide, they can be wherever you like, but this does assume that Column A is stored as TEXT.

 

[pklimchuk]

Thanks looking for a Marco