In the below sample, formulas are in the 'Total Due' column and the last totals
row. Enter or change a formula in a cell - "=SUM(C1:C3)" - then press the
Update image link (the checkbox at the bottom left of Spread) to view your
changes.
| | Customer | Invoice | Total Due | Aged Receivables |
| 0-30 | 31-60 | 61+ |
| 1 | Around the Horn | 10365 | $503.2 | $503.2 | $0 | $0 |
| 2 | 10507 | $1,648.5 | $0 | $0 | $1,648.5 |
| 3 | 10535 | $395.2 | $0 | $395.2 | $0 |
| 4 | 10573 | $542.5 | $542.5 | $0 | $0 |
| 5 | | | $3,089.4 | $1,045.7 | $395.2 | $1,648.5 |
|
|
| Date and Time Functions |
| DATE
|
DATEDIF
|
DATEVALUE
|
DAY
|
| DAYS360
|
EDATE
|
EOMONTH
|
HOUR
|
| MINUTE
|
MONTH
|
NETWORKDAYS
|
NOW
|
| SECOND
|
TIME
|
TIMEVALUE
|
TODAY
|
| WEEKDAY
|
WEEKNUM
|
WORKDAY
|
YEAR
|
| YEARFRAC
|
|
|
|
Engineering Functions |
| BESSELI
|
BESSELJ
|
BESSELK
|
BESSELY
|
| BIN2DEC
|
BIN2HEX
|
BIN2OCT
|
COMPLEX
|
| CONVERT
|
DEC2BIN
|
DEC2HEX
|
DEC2OCT
|
| DELTA
|
ERF
|
ERFC
|
GESTEP
|
| HEX2BIN
|
HEX2DEC
|
HEX2OCT
|
IMABS
|
| IMAGINARY
|
IMARGUMENT
|
IMCONJUGATE
|
IMCOS
|
| IMDIV
|
IMEXP
|
IMLN
|
IMLOG10
|
| IMLOG2
|
IMPOWER
|
IMPRODUCT
|
IMREAL
|
| IMSIN
|
IMSQRT
|
IMSUB
|
IMSUM
|
| OCT2BIN
|
OCT2DEC
|
OCT2HEX
|
|
Financial Functions |
| ACCRINT
|
ACCRINTM
|
AMORDEGRC
|
AMORLINC
|
| COUPDAYS
|
COUPDAYBS
|
COUPDAYSNC
|
COUPNCD
|
| COUPNUM
|
COUPPCD
|
CUMIPMT
|
CUMPRINC
|
| DB
|
DDB
|
DISC
|
DOLLAR
|
| DOLLARDE
|
DOLLARFR
|
DURATION
|
EFFECT
|
| EURO
|
EUROCONVERT
|
FV
|
FVSCHEDULE
|
| INTRATE
|
IPMT
|
IRR
|
ISPMT
|
| MDURATION
|
MIRR
|
NOMINAL
|
NPER
|
| NPV
|
ODDFPRICE
|
ODDFYIELD
|
ODDLPRICE
|
| ODDLYIELD
|
PMT
|
PPMT
|
PRICE
|
| PRICEDISC
|
PRICEMAT
|
PV
|
RATE
|
| RECEIVED
|
SLN
|
SYD
|
TBILLEQ
|
| TBILLPRICE
|
TBILLYIELD
|
VDB
|
XIRR
|
| XNPV
|
YIELD
|
YIELDDISC
|
YIELDMAT
|
Information Functions |
| COUNTBLANK
|
ERRORTYPE
|
ISBLANK
|
ISERR
|
| ISERROR
|
ISEVEN
|
ISLOGICAL
|
ISNA
|
| ISNONTEXT
|
ISNUMBER
|
ISODD
|
ISREF
|
| ISTEXT
|
N
|
NA
|
TYPE
|
Logical Functions |
| AND
|
FALSE
|
IF
|
NOT
|
| OR
|
TRUE
|
|
|
Look Up Functions |
| ADDRESS
|
CHOOSE
|
COLUMNS
|
HLOOKUP
|
| INDEX
|
LOOKUP
|
ROWS
|
TRANSPOSE
|
| VLOOKUP
|
|
|
|
Math and Trigonometry Functions |
| ABS
|
ACOS
|
ACOSH
|
ASIN
|
| ASINH
|
ATAN
|
ATAN2
|
ATANH
|
| CEILING
|
COMBIN
|
COS
|
COSH
|
| COUNTIF
|
DEGREES
|
EVEN
|
EXP
|
| FACT
|
FACTDOUBLE
|
FLOOR
|
GCD
|
| INT
|
LCM
|
LN
|
LOG
|
| LOG10
|
MDETERM
|
MINVERSE
|
MMULT
|
| MOD
|
MROUND
|
MULTINOMIAL
|
ODD
|
| PI
|
POWER
|
PRODUCT
|
QUOTIENT
|
| RADIANS
|
RAND
|
RANDBETWEEN
|
ROMAN
|
| ROUND
|
ROUNDDOWN
|
ROUNDUP
|
SERIESSUM
|
| SIGN
|
SIN
|
SINH
|
SQRT
|
| SQRTPI
|
SUBTOTAL
|
SUM
|
SUMIF
|
| SUMPRODUCT
|
SUMSQ
|
SUMX2MY2
|
SUMX2PY2
|
| SUMXMY2
|
TAN
|
TANH
|
TRUNC
|
Statistical Functions |
| AVEDEV
|
AVERAGE
|
AVERAGEA
|
BETADIST
|
| BETAINV
|
BINOMDIST
|
CHIDIST
|
CHIINV
|
| CHITEST
|
CONFIDENCE
|
CORREL
|
COUNT
|
| COUNTA
|
COVAR
|
CRITBINOM
|
DEVSQ
|
| EXPONDIST
|
FDIST
|
FINV
|
FISHER
|
| FISHERINV
|
FORECAST
|
FREQUENCY
|
FTEST
|
| GAMMADIST
|
GAMMAINV
|
GAMMALN
|
GEOMEAN
|
| GROWTH
|
HARMEAN
|
HYPGEOMDIST
|
INTERCEPT
|
| KURT
|
LARGE
|
LINEST
|
LOGEST
|
| LOGINV
|
LOGNORMDIST
|
MAX
|
MAXA
|
| MEDIAN
|
MIN
|
MINA
|
MODE
|
| NEGBINOMDIST
|
NORMDIST
|
NORMINV
|
NORMSDIST
|
| NORMSINV
|
PEARSON
|
PERCENTILE
|
PERCENTRANK
|
| PERMUT
|
POISSON
|
PROB
|
QUARTILE
|
| RANK
|
RSQ
|
SKEW
|
SLOPE
|
| SMALL
|
STANDARDIZE
|
STDEV
|
STDEVA
|
| STDEVP
|
STDEVPA
|
STEYX
|
TDIST
|
| TINV
|
TREND
|
TRIMMEAN
|
TTEST
|
| VAR
|
VARA
|
VARP
|
VARPA
|
| WEIBULL
|
ZTEST
|
|
|
Text Functions |
| CHAR
|
CLEAN
|
CODE
|
CONCATENATE
|
| DOLLAR
|
EXACT
|
FIND
|
FIXED
|
| LEFT
|
LEN
|
LOWER
|
MID
|
| PROPER
|
REPLACE
|
REPT
|
RIGHT
|
| SUBSTITUTE
|
T
|
TRIM
|
UPPER
|