Sum of names in Excel
Solved
sylwil
Posted messages
14
Status
Membre
-
AhlemNAGMAR -
AhlemNAGMAR -
Hello,
In Excel, I am looking for how to sum names.
For example, I would like to create a table with the days of the week on the x-axis and the collaborators on the y-axis.
The goal is to indicate whether the person is at work, on leave, etc.
For each day, I would like to know the number of people at work, on leave, etc., which means converting the number of leaves (for example) into a number. What formula should I use?
Thank you in advance
In Excel, I am looking for how to sum names.
For example, I would like to create a table with the days of the week on the x-axis and the collaborators on the y-axis.
The goal is to indicate whether the person is at work, on leave, etc.
For each day, I would like to know the number of people at work, on leave, etc., which means converting the number of leaves (for example) into a number. What formula should I use?
Thank you in advance
Configuration: Windows XP Firefox 3.0.2
6 réponses
Use the COUNTA function, which counts the values (numerical or not) in the range of cells.
--
Why complicate life by making it simple when it's so easy to make it complicated?
--
Why complicate life by making it simple when it's so easy to make it complicated?
fat.barouki
This function works very well, thank you so much :) LatelyGeek
AhlemNAGMAR
Thank you very much, this function works very well. LatelyGeek
