Looking for how to:

Example
a b c d e f g
h
1 Jan paid Feb paid march pd $total paid $total
not paid
2 $30 N $25 N $22 Y (need formula)
(need formula)

i would like to create a formula for $total not paid cell H2. Any time
there is a "n" in a cell, I would like the amount in the cell to the
immediate left of all "n" to sum up keep a running total in the H2 cell,
$total not paid. then I would create a second formula for the "y" for
the $total paid for G2 cell.

Can anyone help with a formula?

mary


--
MARY