ビジネスオフィス開発/Excel関数/リファレンス - パソコン忘備録

リファレンス

バージョン対応 / 引数・記述例

317件	機能・意味	Excelバージョン
		2000	2002	2003	2007	2010	2013
AVERAGE	平均値（数字以外は除く）	●	●	●	●	●
AVERAGEA	平均値（全て対象）	●	●	●	●	●
AVERAGEIF	平均値（条件）				●	●
AVERAGEIFS	平均値（複数条件）				●	●
DSUM	集計（条件）	●	●	●	●	●
MEDIAN	中央値	●	●	●	●	●
MODE	最頻値	●	●	●	●	●
MODE.MULT	最頻値（複数の最頻値）					●
MODE.SNGL	最頻値（１つの最頻値）					●
SUM	合計	●	●	●	●	●
SUMIF		●	●	●	●	●
SUMIFS		●	●	●	●	●
SUBTOTAL		●	●	●	●	●
SUMPRODUCT		●	●	●	●	●
COUNT		●	●	●	●	●
COUNTA		●	●	●	●	●
COUNTBLANK		●	●	●	●	●
COUNTIF		●	●	●	●	●
COUNTIFS		●	●	●	●	●
DCOUNT		●	●	●	●	●
DCOUNTA		●	●	●	●	●
FREQUENCY		●	●	●	●	●
CEILING		●	●	●	●	●
CEILING.PRECISE
ISO.CEILING
EVEN
FIXED
FLOOR
FLOOR.PRECISE
INT
MOD
MROUND
ODD
QUOTIENT
ROUND
ROUNDUP
ROUNDDOWN
TRUNC
LARGE
MAX
MIN
RANK
RANK.AVG
RANK.EQ
SMALL
DATE
DATEDIF
DATESTRING
DATEVALUE
DAY
EDATE
EOMONTH
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
NOW()
TODAY()
WEEKDAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL
YEAR
HOUR
MINUTE
SECOND
TIME
TIMEVALUE
ASC
FIND
JIS
LEFT
LEN
LENB
LOWER
MID
NUMBERSTRING
PHONETIC
PROPER
RIGHT
SEARCH
UPPER
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
REPLACE
REPT
SUBSTITUTE
TEXT
TRIM
YEN
ADDRESS
CHOOSE
COLUMN・COLUMNS
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW・ROWS
TYPE
VLOOKUP
AND
EXACT
IF
IFERROR
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNONTEXT
ISNUMBER
ISODD
ISTEXT
N
NA
OR
ABS
AGGREGATE
COS
DEGREES
EXP
FACT
LN
LOG
LOG10
PI()
POWER
RADIANS
RAND
RANDBETWEEN
SIGN
SIN
SQRT
TAN
TEXT
VALUE
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DSUM
PMT
PV
FV
RATE
NPER
CONVERT
DELTA
GESTEP
CELL
INFO
ABS
ADDRESS
AGGREGATE
AND
ASC
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
CEILING
CEILING.PRECISE
CELL
CHAR
CHOOSE
CLEAN
COLUMN・COLUMNS
CODE
CONCATENATE
CONVERT
COS
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DATE
DATEDIF
DATESTRING
DATEVALUE
DAVERAGE
DAY
DCOUNT
DCOUNTA
DEGREES
DELTA
DGET
DMAX
DMIN
DOLLAR
DSUM
EDATE
EOMONTH
EVEN
EXACT
FACT
FIND
FIXED
FLOOR
FLOOR.PRECISE
FREQUENCY
FV
GESTEP
HLOOKUP
HOUR
HYPERLINK
IF
IFERROR
INDEX
INDIRECT
INFO
INT
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNONTEXT
ISNUMBER
ISODD
ISTEXT
ISO.CEILING
JIS
LARGE
LEFT
LEN
LENB
LN
LOG
LOG10
LOOKUP
LOWER
MATCH
MAX
MEDIAN
MID
MIN
MINUTE
MOD
MODE
MODE.MULT
MODE.SNGL
MONTH
MROUND
EXP
N
NA
NETWORKDAYS
NETWORKDAYS.INTL
NOW()
NPER
NUMBERSTRING
ODD
OFFSET
OR
PHONETIC
PI()
PMT
POWER
PROPER
FV
QUOTIENT
RADIANS
RAND
RANDBETWEEN
RANK
RANK.AVG
RANK.EQ
RATE
REPLACE
REPT
RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROW・ROWS
SEARCH
SECOND
SIGN
SIN
SMALL
SQRT
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
TAN
TEXT
TIME
TIMEVALUE
TODAY()
TRIM
TRUNC
TYPE
UPPER
VALUE
VLOOKUP
WEEKDAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL
YEAR
YEN
＆(演算子)
* ？(ワイルドカード文字)