











Sum by month 
EOMONTH 




















Sum if cells contain both x and y 







Sum if date is greater than 
DATE SUMIF 
Sum if ends with 
SUMIF 
Sum if equal to either x or y 
SUMIF SUMPRODUCT 
Sum if greater than 
SUMIF 
Sum if less than 
SUMIF 
Sum if multiple criteria 

Sum if not blank 
SUMIF 
Sum top n values 
INDIRECT ROW SUM SUMPRODUCT LARGE 
Sum visible rows in a filtered list 
SUBTOTAL 