在Google Docs的Spreadsheet中用SUMIFS

早前發現,原來Google Docs的試算表Spreadsheet沒有Excel裡將符合多個條件的儲存格進行加數的SUMIFS,只有用於單一條件的SUMIF。 如果要在Google Docs的Spreadsheet用SUMIFs的話,就要用上另一條公式: =sum(filter(D2:D11,C2:C11= “John”;B2:B11=”Q3″;A2:A11=2010)) Count, COUNTIF和COUNTIFs也可以用同樣方式對付!

[Continue reading]

Top Ten List on Using a Computer in an Office

10. If you got problems, you should try turn the machine off and turn it on again. 09. USB is a port (or an input-output interface) on a modern computer, not a storage device. 08. Microsoft Powerpoint is for On-screen presentation, NOT note printing, please use Word for that. 07. Microsoft Word is for simple…

[Continue reading]