I am trying to figure out the formula for a sumif with multiple criteria. I have a separate worksheet named "Sales" Column A list the date, column B list the month, column C list the Year and column D list sales for the particular day. I would like, on a separate worksheet named "SalesReports", to have a dropdown list in cell A1 to select the month and another in cell B1to select the year. Based off that criteria I would like the formula to sum all the sales data in column D from the "Sales" sheet. Hopefully, this make sense. Any assistance is greatly appreciated. Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sumif with multiple criteria
- Thread starter BT63
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,265
- Office Version
- 365
- Platform
- Windows
Similar to "SUMIF", there is "SUMIFS", which allows for multiple criteria.
See: SUMIFS function - Microsoft Support
See: SUMIFS function - Microsoft Support
Upvote
0
Solution
