SOLVED

Add up availability per month

Copper Contributor

Hi everyone

I have a overview about the availability of several person. On each day, the person is wether availabile (1) or not (0). Every Column in excel is one day from a specific month. See following picture

asadiku_0-1687425999075.png

 

The Dates are until end of the year.

 

I want now for each month a summary of the available days for each person. How can I do that in Excel?

 

Thank for your help

1 Reply
best response confirmed by asadiku (Copper Contributor)
Solution

@asadiku 

In the attached sample workbook, both the months and the day numbers are dates, properly formatted.

1 best response

Accepted Solutions
best response confirmed by asadiku (Copper Contributor)
Solution

@asadiku 

In the attached sample workbook, both the months and the day numbers are dates, properly formatted.

View solution in original post