Excel DSUM formula

Excel's DSUM formula is a useful alternative to VLOOKUP. It will read the column headings of an array of data, and return the sum based on criteria entered in separate set of cells.

In this example, the DSUM formula:

=DSUM(B8:E33,"Wins",B2:C4)

. . . makes references to the data in B8:E33, and is set to add up the numbers in the 'Wins' column. The array given at the end of the formula checks the criteria to use in filtering down the numbers to add up. So the result will be 59, the number of wins for the listed Mets pitchers in 1971 and 1990.

Geek Uninstaller

A standard procedure to follow in order to confirm that your PC is not infected with any malware is to remove any toolbars which have been installed. Geek Uninstaller, available for download here, is designed to assist with the removal of programs which cannot be uninstalled by your operating system.

Geek Uninstaller will list both toolbars and all programs installed on your PC.

Third party uninstalling programs like Geek Uninstaller will get rid of folders, shortcuts, registry entries and temporary files that Windows may leave in place.

Beyond Attorney-Client Communications and Work Product in Privilege Review

If you are conducting a review for privileged documents and looking for an authoritative guide, consult A Practitioner's Summary Guide To The Attorney-Client Privilege And The Work Product Doctrine, posted by McGuire Woods LLP. In addition to looking for attorney-client communications, and checking to see if there are documents which constitute work product, keep in mind the following key points about privilege review:

1. Fiduciary Exception - a beneficiary cannot be denied access to communications between a lawyer and a trustee about the administration of a trust.

2. Garner Doctrine - the shareholders of a corporation may have access to attorney-client communications, because they are the true clients. Not all courts accept the Garner Doctrine.

3. Settlor Exception - the fiduciary exception does not apply to the creation or termination of ERISA plans.

4. Unprotected Background Information - logistical details of an attorney-client relationship are not protected. So for example, the date a client was referred to an attorney, or the length of an attorney's representation of a client would not be protected.

5. Crime-Fraud Exception - communications about a client's criminal, fraudulent, or egregiously improper conduct are not protected. This applies to future acts, not acts which have already be taken.

6. Joint Defense / Common Interest Doctrine - co-defendants can share privileged communications without waiving the protection. The represented parties will usually have to anticipate litigation in order for the communications to be protected.

7. Implied Waiver - privilege can be waived if the holder of the privilege relies on the communications.

8. Overcoming Work Product Protection - the protection may not apply in subsequent, unrelated litigation. A criminal defendant who is exonerated can request work product in a later civil case.

9. Federal Rule of Evidence 612 - documents used to refresh a witness's recollection must be disclosed.

10. Subject Matter Waiver - is more common for attorney-client communications than for work product. Disclosing a non-testifying expert's report and producing work product in discovery to a third party does not result in subject matter waiver, but using work product in testimony or letting an employee keep work product after they are terminated will result in subject matter waiver.

11. Hearn Doctrine - at issue waiver can take place if a party asserts knowledge or ignorance of an important fact. So if the privileged communications will determine the outcome of a case, and there is no other source for the relevant information, then privilege can be waived.