Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WRITING A WHAT IF FUNCTION
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WRITING A WHAT IF FUNCTION
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing UDF Help | Excel Discussion (Misc queries) | |||
Why doesn't writing a nested IF function work? | Excel Discussion (Misc queries) | |||
Help Writing Function | Excel Worksheet Functions | |||
Writing to csv | Excel Discussion (Misc queries) | |||
Writing a formula | Excel Worksheet Functions |