Sum of names in Excel Solved

Question

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

Configuration: Windows XP Firefox 3.0.2

LatelyGeek · Accepted Answer

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?

sylwil · Answer

Thank you,  I will test it.

sylwil · Answer

According to what I found online, NBVAL allows you to count the number of cells containing data in a range of cells. So if I understand correctly, it doesn't matter what the cell contains.
How can I make it count the number of cells based on the text they contain? As many cells with "congé", as with "travail", etc...

sylwil · Answer

I think I found =COUNTIF(range, criteria) should do the trick

Raymond PENTIER · Answer

Exactly! That's the right function. And if I were you, I would name the range to make the formula copying easier. -- It's nice, retirement! Especially in the Caribbean... :-) Raymond

LatelyGeek · Answer

Sorry, I read the opposite, a leave column and a work column. I will learn to read the statements... -- Why make life complicated by keeping it simple when it's so easy to make it complicated?

Sum of names in Excel

6 answers

Incompatible display driver

Where are my smartphone backup data stored?

Trail camera requires a code

Convert video mov file

Dictation voice

Choose the format

Format choice

My posts are invisible for no apparent reason

The ctrl key works intermittently

Boot blocked at startup