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 =SUMIF(range,">1000")To sum if greater than, you can use the SUMIF function.In the example shown, cell H7 contains ...

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 SUMIF =SUMIF(range,">"&DATE(year,month,day),sum_range)To sum if based on dates greater than a certain date, you can ...

Windows shortcut  AltEnter Mac shortcut  ⌃⌥Return Use this shortcut when you need to start a new line inside a cell. Notes: You can use this ...

Windows shortcut  Alt Mac shortcut  ⌘ Use this shortcut to snap objects to the Excel grid, including  including charts, shapes, smart art, and ...

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 ...