在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也可以用同樣方式對付!

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 document to print out on a laser or inkjet printer, NOT for publishing a 300 pages book.

06. You can email a line of text in an email, you don’t NEED to type a sentence in a Word Document, save it and attach it in an Email.

05. You can also email with a PICTURE as attachment, you can add them just like attaching your favorite Word or Excel Documents. You don’t NEED to put a JPEG photo in a Word Document, save it and attach it in an Email.

04. People can actually read your email faster than you press the print button, go pick up your print out , then walk to their desk with a piece of paper with a line of text on it. If they don’t have any respond from your email, they’re probably ignoring you.

03. You can save a HTML file from Word or Microsoft Frontpage and uploaded it somewhere. But doesn’t mean you know how to do Web-design or “writing a web page”.

02. Don’t click on YES everytime anything pop up with a dialog box, READ first, OUT LOUD if necessary.

01. The blue “e” thingy on your desktop with “Internet Explorer” text under it is NOT the Internet, more like it fucks up the internet!