| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula - IF / OR ???
I'm using Excel 2003 and I'm trying to find a formula that will give me a
total of certain alpha cells. My data is a vacation chart for employees that also shows study leave, maternity leave etc. All leave that is not a vacation has to be shown as letters (e.g. ML = Maternity Leave and SL = Study Leave), but there is only one cell to enter this into as it's assumed that an employee will not be on Maternity leave and study leave at the same itme! Is there a way that I can say, if a range of cells equal ML, count them all and enter the total result e.g. for 3 days showing ML = ML3, whilst also asking it to look for SL, and returning (e.g.) SL2 for 2 study leave days accordingly? Thanks in advance!!! -- Ann |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula - IF / OR ???
Hi,
Try this ="ML= "&COUNTIF(A1:A20,"ml") Mike "Ann" wrote: I'm using Excel 2003 and I'm trying to find a formula that will give me a total of certain alpha cells. My data is a vacation chart for employees that also shows study leave, maternity leave etc. All leave that is not a vacation has to be shown as letters (e.g. ML = Maternity Leave and SL = Study Leave), but there is only one cell to enter this into as it's assumed that an employee will not be on Maternity leave and study leave at the same itme! Is there a way that I can say, if a range of cells equal ML, count them all and enter the total result e.g. for 3 days showing ML = ML3, whilst also asking it to look for SL, and returning (e.g.) SL2 for 2 study leave days accordingly? Thanks in advance!!! -- Ann |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula - IF / OR ???
Hi Mike
This works, thank you! But is there a way to also include SL? The same cell may relate to ML or SL, and I'd like to return a count of either of these in the same destination cell...... -- Ann "Mike H" wrote: Hi, Try this ="ML= "&COUNTIF(A1:A20,"ml") Mike "Ann" wrote: I'm using Excel 2003 and I'm trying to find a formula that will give me a total of certain alpha cells. My data is a vacation chart for employees that also shows study leave, maternity leave etc. All leave that is not a vacation has to be shown as letters (e.g. ML = Maternity Leave and SL = Study Leave), but there is only one cell to enter this into as it's assumed that an employee will not be on Maternity leave and study leave at the same itme! Is there a way that I can say, if a range of cells equal ML, count them all and enter the total result e.g. for 3 days showing ML = ML3, whilst also asking it to look for SL, and returning (e.g.) SL2 for 2 study leave days accordingly? Thanks in advance!!! -- Ann |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula - IF / OR ???
Maybe this
="ML= "&COUNTIF(A1:A20,"ml")&" SL= "&COUNTIF(A1:A20,"sl") Mike "Ann" wrote: Hi Mike This works, thank you! But is there a way to also include SL? The same cell may relate to ML or SL, and I'd like to return a count of either of these in the same destination cell...... -- Ann "Mike H" wrote: Hi, Try this ="ML= "&COUNTIF(A1:A20,"ml") Mike "Ann" wrote: I'm using Excel 2003 and I'm trying to find a formula that will give me a total of certain alpha cells. My data is a vacation chart for employees that also shows study leave, maternity leave etc. All leave that is not a vacation has to be shown as letters (e.g. ML = Maternity Leave and SL = Study Leave), but there is only one cell to enter this into as it's assumed that an employee will not be on Maternity leave and study leave at the same itme! Is there a way that I can say, if a range of cells equal ML, count them all and enter the total result e.g. for 3 days showing ML = ML3, whilst also asking it to look for SL, and returning (e.g.) SL2 for 2 study leave days accordingly? Thanks in advance!!! -- Ann |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula - IF / OR ???
Mike, it worked, you're a star! Thank you so much!
-- Ann "Mike H" wrote: Maybe this ="ML= "&COUNTIF(A1:A20,"ml")&" SL= "&COUNTIF(A1:A20,"sl") Mike "Ann" wrote: Hi Mike This works, thank you! But is there a way to also include SL? The same cell may relate to ML or SL, and I'd like to return a count of either of these in the same destination cell...... -- Ann "Mike H" wrote: Hi, Try this ="ML= "&COUNTIF(A1:A20,"ml") Mike "Ann" wrote: I'm using Excel 2003 and I'm trying to find a formula that will give me a total of certain alpha cells. My data is a vacation chart for employees that also shows study leave, maternity leave etc. All leave that is not a vacation has to be shown as letters (e.g. ML = Maternity Leave and SL = Study Leave), but there is only one cell to enter this into as it's assumed that an employee will not be on Maternity leave and study leave at the same itme! Is there a way that I can say, if a range of cells equal ML, count them all and enter the total result e.g. for 3 days showing ML = ML3, whilst also asking it to look for SL, and returning (e.g.) SL2 for 2 study leave days accordingly? Thanks in advance!!! -- Ann |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula - IF / OR ???
Glad I could help
"Ann" wrote: Mike, it worked, you're a star! Thank you so much! -- Ann "Mike H" wrote: Maybe this ="ML= "&COUNTIF(A1:A20,"ml")&" SL= "&COUNTIF(A1:A20,"sl") Mike "Ann" wrote: Hi Mike This works, thank you! But is there a way to also include SL? The same cell may relate to ML or SL, and I'd like to return a count of either of these in the same destination cell...... -- Ann "Mike H" wrote: Hi, Try this ="ML= "&COUNTIF(A1:A20,"ml") Mike "Ann" wrote: I'm using Excel 2003 and I'm trying to find a formula that will give me a total of certain alpha cells. My data is a vacation chart for employees that also shows study leave, maternity leave etc. All leave that is not a vacation has to be shown as letters (e.g. ML = Maternity Leave and SL = Study Leave), but there is only one cell to enter this into as it's assumed that an employee will not be on Maternity leave and study leave at the same itme! Is there a way that I can say, if a range of cells equal ML, count them all and enter the total result e.g. for 3 days showing ML = ML3, whilst also asking it to look for SL, and returning (e.g.) SL2 for 2 study leave days accordingly? Thanks in advance!!! -- Ann |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
