View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default COUNTIF - Condition

Try sumproduct:
=SUMPRODUCT(--(A2:E10=""),--(B2:F10<""))

assuming you have date from cols A-F and rows 2-10
--
John C


"Sandesh" wrote:

Hi,
I would like to know how I can count only those number of cells in a row
with a particular value which have their adjacent cell on the left without
any value
Example
A B C D E F
1 w 0 w W
2
3
The answer to above should return value of 2