Macro to calculate data from one column based on dates in another column.

Hi there,

Is there a macro where I can calculate data from column H (all numbers), based on the dates in column K?

Obviously on another sheet I'd have a list of all the dates of the year in column A, then in column B I want to calculate the total number entered into cells in column H if the dates in column K equal to the dates in Column A of spreadsheet 2.

Hopefully that makes sense. I know there are formula's to do that but they make my workbook run a bit slower.

Thanks

hi
you can use countif and it works good
but if you want a macro please attache d your file to send a macro based on your file