Hi everyone.
I’ve been looking through so many topics here and many of them were really close to what I’m looking for as a solution but none of them no matter how many times I tried didn’t’ work out for my issue. Obviously I’m not an Excel guru.
I have a situation with Average formulas and many of them I copied from here do work but not in all cases. Basically I have up to 40 students and that number is not the same every day. What’s killing me is different number of students per day. Per instance today there was to be 32, 29 were present, 3 absent and the remaining 8 cells stayed blank. So cells contain ‘X’ which stands for Present, other letters represent absences (hospital, convoy escort, personal issues, on the mission etc…) and blank cells which stands for no students for that day. Now, I’ve managed to make some of the formulas to work for me but I cannot fix an issue where I have columns for days that are yet to come. These cell are blank and no universal formula that could be applied for all columns works. Statistically those columns should say 0% so other formulas can ease calculate weekly and monthly statistics excluding all 0% columns. But I simply cannot make them show 0%. I know it is me so after couple of days trying I gave up, time to call for higher authorities
I have an example attached and I am more than willing to assist in any way possible just to solve this out once and for all. In the attached file I have used many different formulas for the same task, sorry for that. The few cells are highlighted in red, to make it easier where I got stuck. L
By the way, it something like this was covered before than I really apologize, I didn’t find a solution here so far.
https://app.box.com/s/oi017hlbuflb2b14tx0w
I’ve been looking through so many topics here and many of them were really close to what I’m looking for as a solution but none of them no matter how many times I tried didn’t’ work out for my issue. Obviously I’m not an Excel guru.
I have a situation with Average formulas and many of them I copied from here do work but not in all cases. Basically I have up to 40 students and that number is not the same every day. What’s killing me is different number of students per day. Per instance today there was to be 32, 29 were present, 3 absent and the remaining 8 cells stayed blank. So cells contain ‘X’ which stands for Present, other letters represent absences (hospital, convoy escort, personal issues, on the mission etc…) and blank cells which stands for no students for that day. Now, I’ve managed to make some of the formulas to work for me but I cannot fix an issue where I have columns for days that are yet to come. These cell are blank and no universal formula that could be applied for all columns works. Statistically those columns should say 0% so other formulas can ease calculate weekly and monthly statistics excluding all 0% columns. But I simply cannot make them show 0%. I know it is me so after couple of days trying I gave up, time to call for higher authorities
I have an example attached and I am more than willing to assist in any way possible just to solve this out once and for all. In the attached file I have used many different formulas for the same task, sorry for that. The few cells are highlighted in red, to make it easier where I got stuck. L
By the way, it something like this was covered before than I really apologize, I didn’t find a solution here so far.
https://app.box.com/s/oi017hlbuflb2b14tx0w
