Multi-cell Range

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.
 
J

JE McGimpsey

One way:

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

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

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

Problem with calculating hours in timesheet? (sysgulv) 3
Formula works in some cells of a colum but not others? 4
Formula not producing correct result 2
Umh ! 2
Why Am I getting a blank in the result cell? 4
Return Single Row of Numeric Data to Single Column 4
Excel VBA 1
Formula Not Calucating Right 2

Top