Average

M

myname

Joined
Jul 6, 2010
Messages
1
Reaction score
0
Hi all,

Is there any syntax for VBA to check certain column and their criteria then average the values? To be specific, I need to do an average for unitname by month, week, attempt and operator. I have 4 unitname. I will attach the sample workbook.

Please state with I'm not precise enough.

Thanks in advance.
 

Attachments

  • Sample.zip
    9.8 KB · Views: 203

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating average in a large dataset 2
Help with Average formula 3
How to average values based on time period 6
Sumproduct in matrix means 3
Average cells 3
Average / sumproduct based on multiple criteria 3
Average function 9
Average every x cells 3

Top