Prev: pulling data
Next: adding hours and minutes
From: Bob M. Bob on 27 Apr 2010 14:10
I am trying to use the countif function but want to include and exclude
specific cells within the same column.

Row 1 = "4"
Row 2 = "4"
Row 3 = "3"
Row 4 = "4"

Example: I want to count "4" in row 1 & row 4 but not in row 2.

Any help would be appreciated.

Bob M.


From: Jim Thomlinson on 27 Apr 2010 14:29
How do you plan on telling the formula which values/cells to exclude. Is
there some sort of logic...
--
HTH...

Jim Thomlinson


"Bob M." wrote:

> I am trying to use the countif function but want to include and exclude
> specific cells within the same column.
>
> Row 1 = "4"
> Row 2 = "4"
> Row 3 = "3"
> Row 4 = "4"
>
> Example: I want to count "4" in row 1 & row 4 but not in row 2.
>
> Any help would be appreciated.
>
> Bob M.
>
>
 | 
Pages: 1
Prev: pulling data
Next: adding hours and minutes