Is there a way to combine a sumif and a countif function within one formula?


I am trying to find the number of "tasks" completed within a certain date range.

The following are the formulas I have been using, but I can't figure out how to combine them.

=SUMIF({Content Type}, CONTAINS("Wiki", @cell), {Task Counter})

=COUNTIF({Date Received}, >=DATE(2022, 1, 1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!