I have an Excel sheet where column F holds numeric values, yet the three SUMIF formulas below are meant to pull subtotals based on the words “Materials”, “Tools”, and “Trades”: =SUMIF(F:F,"*Materials*",G:G) =SUMIF(F:F,"*Tools*",G:G) =SUMIF(F:F,"Trades",G:G) They currently return zero, so I need a fresh set of eyes to diagnose the mismatch between the data type in column F and the criteria I’m using, then rewrite the formulas so they produce the correct totals in column G. Scope • Review the workbook and pinpoint why each formula fails. • Replace or rewrite them (possibly with SUMIFS or another approach) so the corrected cells return the right figures. • Provide a brief note inside the file or in a short message explaining what you changed and why. No extra conditions are required beyond what you see above—just make the three sums work correctly. If you have a quick, elegant fix and can turn this around fast, I’d love to hand it over to you today.