Functions in VBA

[GabyB]

Hi I was wondering can anyone help me with this problem, I need a way to calculate the max, min, average, median, mode, amount of numbers, amount of positive numbers, amount of negative numbers, amount of numbers that are equal to cero, the sum of all the positive numbers, the sum of all negative numbers, and the sum of all numbers, the problem is that The colum where all the data can be found changes and doesn't have an specific range it just all the numbers found in Column C, also the data is on Worksheet "Table" and the max, min, average etc. must be display of worksheet "Summary" can anyone help me please? it's urgent!

 

[igold]

Have you done any research at all, other than posting here. All the functions you need are very basic and there is a plethora of information on the net.

If it is "urgent", perhaps you should take matters into your own hands.

igold

 

[GabyB]

Hi I did my research and found and it was helpful but do you think you can help me with the Sum of positive and negative numbers I wrote this but it doesn't work...
Sub PositiveSum()

Dim rng As Range
Dim dblSum As Double

Set rng = Hoja2.Range("C2:C100")

If rng > 0 Then
dblSum = Application.WorksheetFunction.Sum(rng)
End If

Worksheets("Resumen").Cells(11, 2).Value = dblSum

End Sub

 

[mikerickson]

Have you looked at the SUM, COUNT, or COUNTIF functions?
There are also AVERAGE, MODE and MEDIAN functions, as well as AVERAGEIF.

 

[MARK858]

@GabyB


What is different to your thread below and why didn't you respond and ask any extra questions there?

http://www.mrexcel.com/forum/excel-questions/929128-functions-visual-basic-applications.html

 

[GabyB]

Oh thanks! guess we are very behind on my class...thanks for the help

 

[GabyB]

There is no diference my computer rebooted and thought the post hadn't submit the first time, I hadn't notice thanks!

 

[MARK858]

There is no diference my computer rebooted and thought the post hadn't submit the first time, I hadn't notice thanks!

Might be of some use subscribing to your threads, at least in that case you will get notified if someone responds to one of your posts (see the link below for info about subscriptions).

Also if you click your username near the top of the page (next to welcome,) you will get a list of what you have posted.

Hope that helps

Setting and Profile Features