=SUMPRODUCT(--(A2:A11="H"),--(B2:B11="W"))
Change 11 to max No of your actual rows or max Excel row (in Excel 2003 it
is 65536, in Excel 2007 you can refer to entire columns: A:A, B:B)

Regards,
Stefi


€žandrew€� ezt Ã*rta:

Hi there. How do i use a formula in a cell to calculate the following
conditions:

Column A = "H" text
Column B = "W" text

It requires both text to appear on the same row before equating it with a
numerical value of 1. Whenever a new row is created, and both "H" and "W"
appears (in column A and B respectively) in the same row, the cell will have
a function to add up to the total number of times a row has both text.

Sorry if the above sounds silly but i'm pretty new to Excel.