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

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

Thanks Luke,

basically i need the same value from the access worksheet in the second
worksheet. But as i said, some data that was '0' was not entered into Access
(as a means of saving time i think), but i still need the zero in the second
worksheet so i didnt think a SUMPRODUCT formula would work!

G

"Luke M" wrote:

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