papayamint
New Member
- Joined
- Mar 14, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hi there! I'm trying to figure out a way to sum a row based on two cells in the same row. I tried to use a sumproduct but I'm getting an error as I have text in my sum range. Any way to ignore the text to just sum the numbers? Maybe sumproduct isn't even the best way to go about this? I'm trying to get the top section to work but finding the month, the total for each section, and sum the corresponding row. Thanks!
Spreadsheet HERE
Spreadsheet HERE