R
Rich
Have a workbook with multiple spreadsheets. With the
exception of the first spreadsheet all are identical.
Each Cell will contain either, "y", "n" or "p". Need to
total up the number of "y"s, "n"s and "p" from each cell
on each sheet on the master spreadsheet.
countif was the perfect function except it does not
support 3-D references,
i.e. countif(Sheet2:sheet13!B4,"y") does not work
The total number of spreadsheet is unknown which also
made the 3-D References attractive, since as long as the
first and last sheets are defined anything added in the
middle is automaticly accounted for.
Anyone know of a better way to do this.
Thanks
Rich
exception of the first spreadsheet all are identical.
Each Cell will contain either, "y", "n" or "p". Need to
total up the number of "y"s, "n"s and "p" from each cell
on each sheet on the master spreadsheet.
countif was the perfect function except it does not
support 3-D references,
i.e. countif(Sheet2:sheet13!B4,"y") does not work
The total number of spreadsheet is unknown which also
made the 3-D References attractive, since as long as the
first and last sheets are defined anything added in the
middle is automaticly accounted for.
Anyone know of a better way to do this.
Thanks
Rich