Question: Which formula correctly counts the number of numeric values in both B4:E4 and G4:I4?

  1. =COUNT(B4:E4&G4:I4)
  2. =COUNT(B4:E4,G4:I4)
  3. =COUNT(B4:E4 G4:I4)
  4. =COUNT(B4:I4)

Answer: The correct answer of the above question is Option D:=COUNT(B4:I4)