Counting Cells that are not continuous

[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

 

[Frank Kabel]

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