Multiple Non-Contiguous Cell Ranges Varying In Length

X

Xxeno Cide

=COUNTIF((E4:E128,H4:H169),10)

This should be counting the number of cells that contain the number ten from column E4:E128 and H4:H169. Instead it returns a #VALUE! Error (A value used in the formula is of the wrong data type). This even happens when I simplify the formula down to just

=COUNTIF((E4:E5,H4:H5),10)
or
=COUNTIF((E4:E5,H5),10)
 
R

Ron Rosenfeld

=COUNTIF((E4:E128,H4:H169),10)

This should be counting the number of cells that contain the number ten from column E4:E128 and H4:H169. Instead it returns a #VALUE! Error (A value used in the formula is of the wrong data type). This even happens when I simplify the formula down to just

=COUNTIF((E4:E5,H4:H5),10)
or
=COUNTIF((E4:E5,H5),10)
Click to expand...

examine the response to the message you posted, on this topic, about 25 minutes ago.
 
Top