Hello,

Does anyone know how to select noncontiguous ranges or cells for the
inclusion into formulas?. Take a look at a formula I pasted below.
A friend at work entered this and it works for what I want to do,
but, I need to do this for up to 124 cells in a sheet, that are
noncontiguous. Looking at my formula you will see where I'm having to
"countif" each cell separately. We believe there is a better way, but
can't seem to find an example anywhere. All suggestions appreciated!

Mark

=COUNTIF((Chemistry!$D$3),D5)+COUNTIF((Chemistry!$ D$10),D5)
+COUNTIF((Chemistry!$D$17),D5)+COUNTIF((Chemistry! $D$24),D5)
+COUNTIF((Chemistry!$D$31),D5)+COUNTIF((Chemistry! $D$44),D5)