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