Try something like:

=SUMIF(B1:B100,"no",A1:A100)

Note that Worksheet functions are not case sensitive so No and no will both
be picked up.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"MARY" wrote in message
...
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