View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kycajun Kycajun is offline
external usenet poster
 
Posts: 8
Default Calculate average based on date and other criteria

I have a worksheet (sheet 1) which include the following columns:
Audit Date.... Name.... File Score...
(A3:A9949) (D3:D9949) (L3:L9949)

On the next worksheet (sheet 2), I want to calculate a file score average
for all entries belonging to a certain name and on or after a certain date
shown on sheet 1. So for instance I want to calculate a file score average
for Doe, John for all Audit Date entries on or after 7/1/2006.

Any suggestions? Thanks!