If cell C6:Z6 is V1 value must equal 1 If cell C6:Z6 does not contain V value to be 0

Hello!

I need some help creating a formula for a spreadsheet that shows employees remaining PTO.


I have attached a picture of what I need to do. In the Vacation column I need it it add up all of the "V" values, the Birthday coulumn shouel add all of the "B" values etc.

The first row the Vacation column should be 28

The second column should have a 4 in the Birthday coulumn and an 8 in the Birthday coulumn

The third row should have an 8 in the Floating holiday coulumn and an 8 in the Personal column







Thanks!