Xiaopei's DokuWiki

These are the good times in your life,
so put on a smile and it'll be alright

User Tools

Site Tools


it:numbers

电子表格 excel numbers

excel, numbers, etc

functions

时区转换/时间计算

How To Add Time In Excel Or Numbers | Jonathan Laliberte

The reason for this is that Excel (and Numbers, and.. most likely any other spreadsheet software out there) keeps track of dates, not time – so if you have a date of 6/19/2009, and in the next cell you want 6/20/2009 – you add 1. Well, there are 1440 minutes in a day, so you simply have to add a fraction of a day equal to the amount of time you want to add. So 15/1440 = 0.0104166667 days.

vlookup

=VLOOKUP(search-for,columns-range,return-column,close-match)

countif

计算其 A 列与当前表 A2 值相同 TABLE1 的行数:

=COUNTIF(table1 :: $A,A2)

countifs

计算其 A 列与当前表 A2 值相同, 且其 F 列值为忽略的 TABLE1 的行数:

=COUNTIFS(table1::A,A2,table1::Task,"=忽略")

sumifs

=SUMIFS(syslog 统计 :: 总数,syslog 统计 :: $A,">=07/26/13",syslog 统计 :: $A,"<=08/01/13")
it/numbers.txt · Last modified: 2017/07/14 11:57 by admin