Formula - IF / OR ???

[Ann]

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!!!

 

[Mike H]

Hi,

Try this

="ML= "&COUNTIF(A1:A20,"ml")

Mike

 

[Ann]

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......

 

[Mike H]

Maybe this

="ML= "&COUNTIF(A1:A20,"ml")&" SL= "&COUNTIF(A1:A20,"sl")

Mike

 

[Ann]

Mike, it worked, you're a star! Thank you so much!

 

[Mike H]

Glad I could help

Mike, it worked, you're a star! Thank you so much!