Function Problems

Combine Multiple SUMIFS Results with Labels in One Excel Cell

Steve KSteve K Nov 12, 2026 868 views

Question details

Combine multiple SUMIFS counts, such as fabricator and field worker totals, into one labeled cell for each date in a Gantt chart.

Combine Multiple SUMIFS Results with Labels in One Excel Cell
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the fabricator calculation

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.

2
Add the field worker calculation

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.

3
Combine the results into one formula

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").

4
Turn on wrapping for the result cell

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.

Join separate SUMIFS results with labels and line breaks
Match the criteria to your data: Replace the example date range, category range, value range, date cell, and category names with the columns and criteria used in your workbook.
Work with SUMIFS in WPS Spreadsheets

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. 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. 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. 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. 4. Enable Wrap Text: Select the result cells and choose Home > Wrap Text so each worker category is displayed on its own line.
  5. 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.
Use SUMIFS to total Fabricator, Fieldworker, and other categories by date.Combine labels and calculated values with line breaks in a single schedule cell.Open and edit Microsoft Excel .xlsx files with formula compatibility.Use a familiar spreadsheet interface for Gantt charts and project staffing schedules.
microsoft office alternative - wps office

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.