Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Formula to determine if cells contain certain data
Can anyone help me, I am really in need of a formula on how to deal with the
following setup: A. Over various worksheets within my Workbook I am entering a Y or N. B. On my totals page I need to be able to capture if a N entry has been made by showing No. C. If no N entries have been made I do not want to have anything shown. Is there any formula that I can use to show this. |
#2
|
|||
|
|||
One way
=IF(COUNTIF(Range,"=n"),COUNTIF(Range,"=n"),"") HTH Michael Mitchelson "C Anderson" wrote: Can anyone help me, I am really in need of a formula on how to deal with the following setup: A. Over various worksheets within my Workbook I am entering a Y or N. B. On my totals page I need to be able to capture if a N entry has been made by showing No. C. If no N entries have been made I do not want to have anything shown. Is there any formula that I can use to show this. |
#3
|
|||
|
|||
No need for =n, n suffices,
=IF(COUNTIF(range,"n"),"No","") -- HTH RP (remove nothere from the email address if mailing direct) "Michael" wrote in message ... One way =IF(COUNTIF(Range,"=n"),COUNTIF(Range,"=n"),"") HTH Michael Mitchelson "C Anderson" wrote: Can anyone help me, I am really in need of a formula on how to deal with the following setup: A. Over various worksheets within my Workbook I am entering a Y or N. B. On my totals page I need to be able to capture if a N entry has been made by showing No. C. If no N entries have been made I do not want to have anything shown. Is there any formula that I can use to show this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
changing the way Excel displays selected cells | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) |