Sum values by month for charting

Sorry if this is a duplicate post, I was in the middle of typing my post and I hit something with my pinky and it disappeared.

I ahve a series of invoice values in columns a & b and the dates of those invoices in column c. I am trying to program a macro to total all invoice values by month & year, and put that data elsewhere so I can chart monthly billings. I tried SUMIF but did not have any luck getting it to work. Data is laid out:

Invoice value A Invoice value b Invoice date
$$$$ $$$$ mm/dd/yy

thanks

Try this UDF.

=sumOfMonth(myDate) can be used in a spreadsheet formula.

If the value in column C is a date in the same month as myDate then the values in columns A and B on that row are added into sumOfMonth.

You may need to change the name of the sheet where you keep your data.

Please Login or Register  to view this content.

I'm not sure, but I'll betcha that the SUMPRODUCT is faster than this.

Thanks for the input. I'll give these a try tomorrow after I finish paying my taxes.