worksheetfunction.average

  1. B

    how to store dates/times in array and use WorksheetFunction.Average to find average time

    Hello, this is my first time on mr. excel so I hope I do not mess up anything in the post. I have to create what is basically an averaging program. The data (thousands of points) is imported from a notepad file and i need to create a userform/macro that accepts a block size and compresses...
  2. D

    how to use worksheetfunction.averageif, with multiple variables

    Hi All, I have 5 different values in five variables, in that some values are negative, so i want to take average only for positive values.. plz help me thanks Deepak
  3. J

    Average of Named Range

    Hello, I have a long string of numbers, some negative some positive (representing a Sine curve). I am trying to average consecutive set of positive and negative numbers (average the 10 positive numbers, then 9 negative numbers, then the following 11 positive numbers, etc) I currently have...
  4. F

    Unable to get average property of Worksheetfunction class

    I am trying to calculate average and SD from data which has different start points on a worksheet. The data is in column I and the first set starts at I2 and varies where it finishes. The second set starts 6 rows below where the first set ends. Cells(2,16).Value =...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top