Schokuspokus
New Member
- Joined
- Oct 25, 2005
- Messages
- 9
The following formula only shows a result in the cell if the source data table is opened. It shows #value! until the source file is oped. Is there any way around it?
=sumif('S:\abteilungen\Kundencenter_LTG\reporting\bla\Statistiken\[Masterdatei bla.xls]Tagesaddition'!$AG$2:$AG$2639,"="&A2,'S:\abteilungen\Kundencenter_LTG\reporting\bla\Statistiken\[Masterdatei bla.xls]Tagesaddition'!$AE$2:$AE$2639)/(countif('S:\abteilungen\Kundencenter_LTG\reporting\bla\Statistiken\[Masterdatei bla.xls]Tagesaddition'!$AG$2:$AG$2639,"="&A2))
Thanks for your help.
=sumif('S:\abteilungen\Kundencenter_LTG\reporting\bla\Statistiken\[Masterdatei bla.xls]Tagesaddition'!$AG$2:$AG$2639,"="&A2,'S:\abteilungen\Kundencenter_LTG\reporting\bla\Statistiken\[Masterdatei bla.xls]Tagesaddition'!$AE$2:$AE$2639)/(countif('S:\abteilungen\Kundencenter_LTG\reporting\bla\Statistiken\[Masterdatei bla.xls]Tagesaddition'!$AG$2:$AG$2639,"="&A2))
Thanks for your help.