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.






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.

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.

Sean O'Shea has more than 15 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

 

All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.

 

This policy is subject to change at any time.

 

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com