COUNTIF between multiple worksheets

[Harrassed]

I set up countif to work on multiple worksheets (with the
sheets all open at the time), but after I save and close
down the windows I find that when I reopen all of the
"external references" dissappear completely. Example -
=COUNTIF('H:\Rad Vac\[Calendar
2003-V21.xls]August'!$F$3:$F$8,"gc"). It is possible to
get the information to stay constant, as I have other
calculations set up to run on the basis of the countif
data. My goal is to have one source supply data to
multiple workbooks (3 in total).

 

[Debra Dalgleish]

You could use the COUNTIF formula in the source workbook, then link to
that cell.

Or, use SUMPRODUCT to do the count, e.g.:

=SUMPRODUCT(('H:\Rad Vac\[Calendar
2003-V21.xls]August'!$F$3:$F$8="gc")*('H:\Rad Vac\[Calendar
2003-V21.xls]August'!$F$3:$F$8<>""))

I set up countif to work on multiple worksheets (with the
sheets all open at the time), but after I save and close
down the windows I find that when I reopen all of the
"external references" dissappear completely. Example -
=COUNTIF('H:\Rad Vac\[Calendar
2003-V21.xls]August'!$F$3:$F$8,"gc"). It is possible to
get the information to stay constant, as I have other
calculations set up to run on the basis of the countif
data. My goal is to have one source supply data to
multiple workbooks (3 in total).