Example =SUMIFS(sum_rng, crit_rng1, crit1, crit_rng2, crit2)If you need to sum numbers based on multiple criteria, you can use the SUMIFS function.In ...

Example Related FunctionsSUMIF =SUMIF(range,"<1000")To sum if less than, you can use the SUMIF function.In the example shown, cell H7 contains this ...

Example Related FunctionsSUMIF SUMPRODUCT If you need to sum numbers based on other cells being equal to either one value or another (either x or y), ...

Example Related FunctionsSUMIF =SUMIF(range,"*text",sum_range)To sum if cells end with specific text, you can use the SUMIF function.In the example ...

Example Related FunctionsDATE DAY MONTH YEAR =DATE(YEAR(date)+1,MONTH(date),DAY(date))If need to generate a dynamic series of dates with a formula that ...

Example Related FunctionsWEEKDAY WORKDAY IF =WORKDAY(date,1)If need to generate a dynamic series of dates that are workdays only (i.e. Monday through ...