Count average per month

[Link]

Hello all

I would like to kindly ask you for favor.

I am getting a report every month with data covering last three months (see example in the attachment). On the "raw" sheet are the data what I got for processing. I would like to have a macro which will count average of data in column "D" for every month separately. Then the result will be loaded to a table like you can see on the "avg" sheet. The macro should be executable by hitting the "count" button. Pivot table is not applicable as this is just a part of a complex solution where pivot table can not be used.

All replies are appreciated.

Thank you in advance.

[sweep]

Hi,

The data in column A is currently in 2 different formats. Some are dates, others are text. Will this be the case in your application, or is there a standard format the column will be in?

[Link]

Hi sweep,

Sorry for this, it's my mistake. It will be always in date format.

Thank you

[sweep]

Hi, give this a go?

Please Login or Register  to view this content.

[snb]

or

=SUMPRODUCT((TEXT(A2:A3000,"yyyymm")="201103")*(D2:D3000))/SUMPRODUCT((TEXT(A2:A3000,"yyyymm")="201103")*1) 

[Link]

Thank you very much sweep. It works perfectly!