Sounds like you need a SUMPRODUCT function that looks something like
=SUMPRODUCT((RangewithIndividuals = 1)*(RangeWithDates =
DATEVALUE("1/1/2009")*(RangeWithValuesYouWant))

We really need you to better define what you mean by 'link' the two cells
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ghalmaraz" wrote:

Hi

In my workbook I have two worksheets, one of which includes data from
Access, the other presents it in a more managable way. What I need is a
formula that would link two cells across the worksheets IF the individual
(numbered from 1-22) and the date (in dd/mm/yyyy) meet criteria. Also, the
data is incomplete (in that some months there was no data inputted (when a
zero should have been inputted)) would need to show a 'zero'

Any Ideas?

G