Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
precede or follow formula with text
I have two cells, one with a COUNTA formula that adds the total number of
employees and one cell with a COUNTBLANK forumula that adds the number of employees who have not yet attended a mandatory meeting. I'd like to create a third cell that reads "of [COUNTA result] staff members, [COUNTBLANK result] have not attended a meeting" Any thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
precede or follow formula with text
Try this:
="of " & A1 & " staff members, " & A2 & " have not attended a meeting." Change A1 and A2 to whatever cells your Counts are stored in. HTH Elkar "Marge" wrote: I have two cells, one with a COUNTA formula that adds the total number of employees and one cell with a COUNTBLANK forumula that adds the number of employees who have not yet attended a mandatory meeting. I'd like to create a third cell that reads "of [COUNTA result] staff members, [COUNTBLANK result] have not attended a meeting" Any thoughts? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
precede or follow formula with text
It worked like a charm! Thank you.
"Elkar" wrote: Try this: ="of " & A1 & " staff members, " & A2 & " have not attended a meeting." Change A1 and A2 to whatever cells your Counts are stored in. HTH Elkar "Marge" wrote: I have two cells, one with a COUNTA formula that adds the total number of employees and one cell with a COUNTBLANK forumula that adds the number of employees who have not yet attended a mandatory meeting. I'd like to create a third cell that reads "of [COUNTA result] staff members, [COUNTBLANK result] have not attended a meeting" Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove characters in a cell that precede a specific hyphen | Excel Discussion (Misc queries) | |||
Validation - Precede with LR and between 6 and 9 characters long. | Excel Discussion (Misc queries) | |||
Complex Autofill does not follow formula | Excel Discussion (Misc queries) | |||
HOW DO I LINK PAGES ON EXCEL TO FOLLOW SAME LINKED FORMULA? | Excel Worksheet Functions | |||
Inserting rows and having the formula follow | New Users to Excel |