WRITING A WHAT IF FUNCTION

[MARY]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk