Multi-cell Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the COUNTIF( ) function in a formula, and I need the range in this particular function to be composed of multiple cells. However, the cells are not adjacent. For example, I want the function to look at cells B13, D13, F13, H13, and J13, and disregarding all cells in between

What do I need to do

Jeremy N.
 
One way:

Assume your condition is that the target cells are > 0:

=SUMPRODUCT(--(B13:J13>0),--(MOD(COLUMN(B13:J13),2)=0))
 
Back
Top