COUNTIF between multiple worksheets

  • Thread starter Thread starter Harrassed
  • Start date Start date
H

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).
 
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).
Click to expand...
 
Back
Top