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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Range Problem 1
Change Range In COUNTIF Formula Based On Value In A Cell 1
Locate text in range (multiple occurrences) and report other cell insame column? 25
COUNTIF Non Contiguous Cells Q 3
Non-contiguous named range 6
Formula for counting multiple variables in a spreadsheet 6
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Using Multiple, Noncontiguous Ranges in COUNTIF? 0

Top