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.