Counting Cells that are not continuous

  • Thread starter Thread starter Tyler1
  • Start date Start date
T

Tyler1

Here's my dilema.

In my spreadsheet I'm trying to calculate the values for all th
variables located in the ranges, C2:R2, C3:R3,C4:R4, C5:R5, C6:R6
C7:R7, C8:R8, C9:R9, C10:R:10, C11:R11, C12:R12, C13:R13, C14:R14
C15:R15, C16:R16, C17:R17. However, within each of these ranges, I onl
want to count the specific cells within this range that meet the give
criteria of containing a value of 3.

The specific cells are E2, I2, N2, P2; E3, I3, N3, P3; E4, I4, N4, P4
E5, I5, N5, P5; E6, I6, N6, P6; ..........E17, I17, N17, P17. Now th
COUNTIF function would count all 17 cells and find those that fit th
criteria of containing a 3. However, I don't want to count all 1
cells. I only want to count the four cells that I mentioned earlier
Therefore, how can I achieve this goal without having to manually coun
the cells? Please help me!!!

Tyle
 
Hi
you received an answer in your original thread. Please stay in this as
otherwise this new post creates additional effort as Aladin has given
you already the starting point
 
Back
Top