So, I posted the other day asking for a formula and I got one that comes very close, but wasn't able to finish it off. Someone sent me a link but it didn't work so I was out of luck. What I'm trying to do is keep track of how many people are at work on each day. When someone is absent, I will mark their name under that date with a "D". So, I would like a formula that adds all the people on shift. Unfortunately, those names are not contiguous. I want to count certain people that are listed in cell D6,D8,D10,D16,D18,D20,D22. Here is the formula I have so far using ctrl+shift+enter.
=SUM(IF(CHOOSE({1,2,3,4,5,6,7},D6,D8,D10,D16,D18,D20,D22)=0,1))
As you can see, I am very close!! The only problem is that the answer I get is only "6", when I have 7 empty cells. When I enter a "D" into one of the above cells, the total number is reduced by one, which is great! But I want to start off with a total of 7 as an answer to the formula as opposed to 6. I'm not sure where the error in the formula is located. Any help would be greatly appreciated!
=SUM(IF(CHOOSE({1,2,3,4,5,6,7},D6,D8,D10,D16,D18,D20,D22)=0,1))
As you can see, I am very close!! The only problem is that the answer I get is only "6", when I have 7 empty cells. When I enter a "D" into one of the above cells, the total number is reduced by one, which is great! But I want to start off with a total of 7 as an answer to the formula as opposed to 6. I'm not sure where the error in the formula is located. Any help would be greatly appreciated!