## Sum if multiple criteria

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

## Sum if less than

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

## Sum if greater than

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

## Sum if equal to either x or y

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

## Sum if ends with

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

## Sum if date is greater than

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

## Start a new line in the same cell

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

## Snap to grid

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

## Series of dates by year

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

## Series of dates by workdays

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