Count & Sum

COUNTIF, COUNTIFS, SUMIF and SUMIFS in Google Sheets: several conditions, cells that only look blank, partial text matches and date ranges, all tested.