I need to make an array using the following info.

Salesperson January February March
1 2400 3500 2000
2 1500 7000 1000
3 600 450 2100
4 790 240 500
5 1000 1000 1000
6 6300 7000 8000
7 1300 450 700
8 2700 5500 6000
9 4700 4800 4900
10 1200 1300 400

I am making an application that will calculate a bonus of whatever percentage value for all 10 people based on their sales for the three months above. The text box display will show what the bonus will be for all the sales people and how much is paid in bonus total for all.
Thanks in advance for any help.

Rob

Hi there. I hope this will help! ~ Sheryl

``````Dim aRay(9, 3)
aRay(0, 0) = "John Salesman"
aRay(0, 1) = 2400
aRay(0, 2) = 3500
aRay(0, 3) = 2000
aRay(1, 0) = "Sue Seller"
aRay(1, 1) = 1500
aRay(1, 2) = 7000
aRay(1, 3) = 1000
fill in the remaining items here...

Dim x, y As Integer
Dim sales As Double = 0
For x = 0 To aRay.GetUpperBound(0)
sales = 0
For y = 1 To 3
sales += aRay(x, y)
Next
Debug.Print(aRay(x, 0) & " Sales: " & sales)
Next``````
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.