Make Unique Name List and Sum Data

It would be easier if you put your data/days 1 below the other instead of across the sheet, makes things much easier. see the attached

Here is a start for you. I only did the first 4 since it is a bit of work. You should be able to do the rest.

Jacc, that is quite a formula you put together there, nice

However, you have that for 5 days, if the table continues for even 1 more week, your formula will become almost impossible to manage It is also dependant on there being that exact amount if names in each day

If you change the layout of your data to a normalized situation as shown in Sheet2 attached, then you can quickly create a pivot table using Excel's built in function as shown in Sheet3.

If you are not familiar with Pivot Tables, then look at this page and view the videos on Pivot Tables. Very powerful stuff.

http://www.datapigtechnologies.com/ExcelMain.htm

BTW: Review the forum rules. It is suggested that you not bump a thread for at least 24 hours.

I agree with FDibbins and alansidman, these formulas are not a good solution. However, I assume that these 7 days represent a week and that no more days will be added?
If you still want to try here I have done the first two to deal with blank cells:

Formula:

Please Login or Register  to view this content.

It's really starting to run slow on my PC. Converting your data range to a Excel Table would make the ranges in the formulas smaller and it would run faster.
There is also the possibility to make a UDF, that would possibly run faster.