Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |