Google Sheets: How do you ignore text in a sumproduct formula?

[papayamint]

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

 

[Kinjal Doshi]

Hi,
I could get the desired result after changing the Format.
Result is highlighted in yellow given in below link.

Delete-Reply.xlsx

Front Sheet JAN,FEB,MAR OPERATIONS STAFF TOTAL,4200 FINANCE STAFF TOTAL RECEPTION STAFF TOTAL JAN STAFF JAN,OPERATIONS STAFF,Day 1,Day 2,Day 3 JAN,Staff 1, $ 200.00 , $ 200.00 , $ 200.00 JAN,Staff 2, $ 300.00 , $ 300.00 , $ 300.00 JAN,Staff 3, $ 400.00 , $ 400.00 , $ 400.00 JAN,Staff 4, $ 500.00

docs.google.com

Hope someone can help you in getting the result based on your format.

 

[Kinjal Doshi]

Hi,
I could get the desired result after changing the Format.
Result is highlighted in yellow given in below link.

Delete-Reply.xlsx

Front Sheet JAN,FEB,MAR OPERATIONS STAFF TOTAL,4200 FINANCE STAFF TOTAL RECEPTION STAFF TOTAL JAN STAFF JAN,OPERATIONS STAFF,Day 1,Day 2,Day 3 JAN,Staff 1, $ 200.00 , $ 200.00 , $ 200.00 JAN,Staff 2, $ 300.00 , $ 300.00 , $ 300.00 JAN,Staff 3, $ 400.00 , $ 400.00 , $ 400.00 JAN,Staff 4, $ 500.00

docs.google.com

Hope someone can help you in getting the result based on your format.

Please check sheet - Copy of Front Sheet