Click "Go" and select the "SUMSQ" function that shows up in the list below. Then click "OK." Type the desired numbers, such as "5" or "6," or cell numbers, such as "A3" or "C6," into the Number ...

How to use COUNTIF with a text condition. The COUNTIF function can also sum items based on text criteria. If you needed to find out how many items in a list have a particular color, you would do this: ...

The SUMIF function can even sum numbers based on a date — such as values related to a specific date, or before or after a date. Suppose we want to total all the sales that happened on January 15 ...