Pages tagged “countifs”

3 pages in Cellwise.

1. Count with several conditions, including blanks

   COUNTIFS with text, blank and number conditions together.

   countifs cleanup

2. Find duplicates on two columns and across sheets

   Flag rows that repeat on two columns, or that already appear on another sheet or list.

   duplicates countifs cleanup

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