I need a way to allow the user through dropdown boxes or other means such as userform to be able to select for example with year and which category and then it to return a sum value in a different cell. For example a dropdown box to allow them to select year 2023, and a drop down box to allow them to select Blue and then it sums everything from a separate worksheet that contains the information.
Column A is the date, column D is the category and column H is the data I need to sum.
| Table Data.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | RideDATE | TypeID | TYPE | ROUTE | RouteID | CATEGORY | CategoryID | RIDERS | REVENUE | REVENUEID | AMOUNT | NOTES | ||
| 2 | 7/1/2017 | 2 | TODD | TODD | 3 | TODD | 8 | 1703 | ||||||
| 3 | 8/1/2017 | 2 | TODD | TODD | 3 | TODD | 8 | 2166 | ||||||
| 4 | 9/1/2017 | 2 | TODD | TODD | 3 | TODD | 8 | 2805 | ||||||
| 5 | 10/1/2017 | 2 | TODD | TODD | 3 | TODD | 8 | 2995 | ||||||
| 6 | 11/1/2017 | 2 | TODD | TODD | 3 | TODD | 8 | 2695 | ||||||
| 7 | 11/30/2017 | 1 | Fixed | Blue | 1 | Pax <5 | 2 | 10 | ||||||
| 8 | 11/30/2017 | 1 | Fixed | Blue | 1 | Senior/DA | 3 | 232 | ||||||
| 9 | 11/30/2017 | 1 | Fixed | Blue | 1 | ADA-Flex | 4 | 20 | ||||||
| 10 | 11/30/2017 | 1 | Fixed | Blue | 1 | Transfers | 5 | 260 | ||||||
| 11 | 11/30/2017 | 1 | Fixed | Blue | 1 | Promo/Free | 6 | 0 | ||||||
| 12 | 11/30/2017 | 1 | Fixed | Blue | 1 | Fare Revenue | 1 | $691 | ||||||
| 13 | 11/30/2017 | 3 | Special | Special | 4 | Special | 7 | 227 | ||||||
| 14 | 11/30/2017 | 1 | Fixed | Red | 2 | Pax (5-65) | 1 | 306 | ||||||
| 15 | 11/30/2017 | 1 | Fixed | Red | 2 | Pax <5 | 2 | 35 | ||||||
| 16 | 11/30/2017 | 1 | Fixed | Red | 2 | Senior/DA | 3 | 367 | ||||||
| 17 | 11/30/2017 | 1 | Fixed | Red | 2 | ADA-Flex | 4 | 19 | ||||||
| 18 | 11/30/2017 | 1 | Fixed | Red | 2 | Transfers | 5 | 210 | ||||||
| 19 | 11/30/2017 | 1 | Fixed | Red | 2 | Promo/Free | 6 | 11 | ||||||
| 20 | 11/30/2017 | 1 | Fixed | Red | 2 | Fare Revenue | 1 | $339 | ||||||
| 21 | 12/1/2017 | 2 | TODD | TODD | 3 | TODD | 8 | 2354 | ||||||
| 22 | 12/31/2017 | 1 | Fixed | Blue | 1 | Pax (5-65) | 1 | 786 | ||||||
| 23 | 12/31/2017 | 1 | Fixed | Blue | 1 | Pax <5 | 2 | 12 | ||||||
| 24 | 12/31/2017 | 1 | Fixed | Blue | 1 | Senior/DA | 3 | 280 | ||||||
| 25 | 12/31/2017 | 1 | Fixed | Blue | 1 | ADA-Flex | 4 | 21 | ||||||
| 26 | 12/31/2017 | 1 | Fixed | Blue | 1 | Transfers | 5 | 294 | ||||||
| 27 | 12/31/2017 | 1 | Fixed | Blue | 1 | Promo/Free | 6 | 3 | ||||||
Non-Table | ||||||||||||||
Column A is the date, column D is the category and column H is the data I need to sum.
