Counting Cells With Condition

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

=SUMPRODUCT(--(B1: M1="w"),--(A1:L1=23))

HTH,
Barb Reinhardt



"Sandesh" wrote:

> 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