Text and formula

[jmazorra]

In cell F8 I have the following formula: =COUNTIF(K6:K127,"=y") which results in 15

In cell G8 I have the formula: =F8/E7 which gives me a result of 12%

And then in cell E8 I have forumula: =F8& " or " &TEXT(G8,"0%") & " of staff" which gives me the result 15 or 12% of staff

As you see I am using three cells to arrive at one result in E8. Question is: Is there a way to combine all 3 formulas in E8 so that I do not need to hide 2 columns, or is the way I am doing it the correct way.

Thanks

 

[AlphaFrog]

Try something like this...

=COUNTIF(K6:K127,"=y") & " or " &TEXT(COUNTIF(K6:K127,"=y")/E7,"0%") & " of staff"

 

[jmazorra]

That worked perfectly

Thanks

 

[jmazorra]

On last thing:

Will the same work for:

=SUM(IF('All Employees Annualized'!M6:M127="maLE",IF('All Employees Annualized'!J6:J127>=40,1,0)))

 

[AlphaFrog]

If you have Excel 2007 or later...
=COUNTIFS('All Employees Annualized'!M6:M127,"maLE",'All Employees Annualized'!J6:J127.">=40")

If you have Excel 2003 or earlier...
=SUMPRODUCT(('All Employees Annualized'!M6:M127="maLE")*('All Employees Annualized'!J6:J127>=40))

 

[jmazorra]

Thank you

That worked perfectly