Pages tagged “sumifs”

3 pages in Cellwise.

1. Monthly totals by category with SUMIFS and EDATE

   Build a category-by-month grid from a list of transactions with one SUMIFS formula you can fill across and down.

   sumifs dashboard dates

2. Sum if a cell contains text (wildcards)

   SUMIFS with asterisks to total rows whose text contains a word.

   sumifs wildcards text

3. Sum or count between two dates in Excel and Google Sheets

   Use SUMIFS and COUNTIFS with two date conditions to total or count a date range.

   dates sumifs countifs

All pages