- 1 (30.51 KiB) Viewed 80 times
- A B с D 1 Total Widgets Sold (TWS) - 1st Quarter 2 3 Name January February March 4 Abe 10 100 1,000 5 Bells 10 100 1,0
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
- A B с D 1 Total Widgets Sold (TWS) - 1st Quarter 2 3 Name January February March 4 Abe 10 100 1,000 5 Bells 10 100 1,0
- A B с D 1 Total Widgets Sold (TWS) - 1st Quarter 2 3 Name January February March 4 Abe 10 100 1,000 5 Bells 10 100 1,000 6 Charles 10 100 1,000 7 8 David 10 100 1,000 9 Frank 10 100 1,000 10 11 Harold 10 100 1,000 12 lan 10 100 1,000 13 Jared 10 100 1,000 14 Lila 10 100 1,000 15 Matthew 10 100 1,000 16 Total 100 1,000 10,000 Sub SUM TWSO a=0 lastrow = Cells(Rows.Count 1).End [xlUp).Row - 1 For i = 7 To lastrow a = a + Cells(i,5).Value Next Cells(lastrow + 2, 1).Value = "The SUM of TWS is" Cells(lastrow + 2,5).Value = a End Sub 00 The program is incorrect-will not run 2,000 d) 1,000 e 7.000
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!