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