I want to write a function that does the following:

Any cells that have "no" then any cells to the left of the "no" cells will
be added together. -- I have a spreadsheet where rents paid are answered
Yes or NO. I want a cell that totals are unpaid rents. Does this make
sense?
MARY