Combine Multiple SUMIFS Results with Labels in One Excel Cell
Question details
Combine multiple SUMIFS counts, such as fabricator and field worker totals, into one labeled cell for each date in a Gantt chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A project schedule or Gantt chart needs to display different worker-category counts in the same cell for each project day.
- Observed behavior
- The desired result is a single cell that shows each worker category with its calculated count, optionally on separate lines.
Confirm that the source table has separate columns for the work date, worker category, and the value to count or sum. If you use line breaks in the result, enable Wrap Text for the destination Gantt chart cells.
Join separate SUMIFS results with labels and line breaks
Use this method when each worker category requires its own SUMIFS calculation and both results must appear in one schedule cell.
Build one SUMIFS formula per category, then join the returned values with text using the ampersand operator. CHAR(10) inserts a line break inside the cell.
In the target Gantt chart cell, enter a SUMIFS formula for Fabricators, such as SUMIFS($C$2:$C$100,$A$2:$A$100,B$1,$B$2:$B$100,"Fabricator"), where column A contains dates, column B contains worker categories, column C contains the values to total, and B1 contains the schedule date.
After the first calculation, add a second SUMIFS using the Fieldworker criterion: SUMIFS($C$2:$C$100,$A$2:$A$100,B$1,$B$2:$B$100,"Fieldworker"). Adjust the ranges and category text to match your table.
Join the labeled results with &: ="Fabricators: "&SUMIFS($C$2:$C$100,$A$2:$A$100,B$1,$B$2:$B$100,"Fabricator")&CHAR(10)&"Fieldworkers: "&SUMIFS($C$2:$C$100,$A$2:$A$100,B$1,$B$2:$B$100,"Fieldworker").
Select the result cell or Gantt chart range, then choose Home > Wrap Text so the CHAR(10) line break displays Fabricators and Fieldworkers on separate lines.

Use TEXTJOIN to combine several labeled SUMIFS calculations
Use this option when you need to display three or more worker categories and want a formula that is easier to extend.
Create labeled worker totals in one WPS Spreadsheet cell
WPS Spreadsheets lets you use SUMIFS, text concatenation, CHAR(10), and TEXTJOIN to show multiple worker totals in one Gantt chart cell. Enter the formula once, enable Wrap Text, and fill it across project dates.
- 1. Open the schedule in WPS Spreadsheets: Open your workbook in WPS Office and select the first Gantt chart cell where the worker summary should appear.
- 2. Reference the date and category columns: Identify the source date column, worker-category column, value column, and the header cell containing the current schedule date.
- 3. Enter the combined SUMIFS formula: Type labeled SUMIFS expressions joined with & and CHAR(10), or use TEXTJOIN(CHAR(10),TRUE,...) for multiple categories.
- 4. Enable Wrap Text: Select the result cells and choose Home > Wrap Text so each worker category is displayed on its own line.
- 5. Fill the formula across the timeline: Drag the fill handle across adjacent date columns to calculate the labeled worker totals for each project day.

Frequently Asked Questions
How do I show two SUMIFS values on separate lines in one Excel cell?
Join the two formulas with CHAR(10), for example ="Fabricators: "&SUMIFS(...)&CHAR(10)&"Fieldworkers: "&SUMIFS(...). Then select the cell and choose Home > Wrap Text.
Can SUMIFS count workers instead of summing a numeric worker value?
Yes. If each matching row represents one worker, use COUNTIFS for each category instead of SUMIFS, then concatenate the labeled COUNTIFS results in the same way.
Why does CHAR(10) not display a new line in my Gantt chart cell?
The formula may contain CHAR(10), but the cell must have wrapping enabled. Select the cell, then use Home > Wrap Text; you may also need to increase the row height.
How can I include more than two worker categories in one cell?
Add more labeled SUMIFS expressions joined by &CHAR(10)&, or use TEXTJOIN(CHAR(10),TRUE,...) and add one labeled formula argument for every category.
What should the SUMIFS date criterion reference in a Gantt chart?
Reference the date header for the current Gantt chart column, such as B$1. Keep the source data ranges absolute with $ signs so they do not shift when you fill the formula across the timeline.




