Counting Cells With Condition

  • Thread starter Thread starter Sandesh
  • Start date Start date
S

Sandesh

I use Excel 2003. I would like to know the Syntax for counting number of
cells with a particular value in a row provided the adjacent cells to the
left or to the right of the cell containing the value satifies certain
conditions.
Exapmple:
A B C D E F G H
I J K L M
1 23 w 0 w 23 w 6 w 9
w 23 w w
2
3
I would like to count only those number of cells from A1: M1 with value 'w'
& who have value of '23' in the cell to its left
 
In another row, put a formula in each cell which returns 1 if the corresponding cell in row 1 = 'w' and its neighbour to the left = 23, and 0 otherwise. Then sum these.
 
Back
Top