i trying create duty roster class. background: have weekday , weekend duties. people duties on weekdays 1 point, while on weekends 2. problem: i'm wondering how code table in excel such whenever duty on weekday, recognizes person gets 1 point. my roster such: (where a,b,c row references) a name|points|date duty done on|date duty done on|date duty done on| b name|points|date duty done on|date duty done on|date duty done on| c name|points|date duty done on|date duty done on|date duty done on| i've tried following code, checks if date weekday, , count cell if is: {=sum(--(if(a:a<>", weekday(a:a)={2,3,4,5,6}))} for weekends, create separate column counts weekends, double points. in column called points , sum of weekday , weekend points. unfortunately above formula doesn't work keep getting #na , #value errors , in end i'm unable roster done. assuming have data shown in image below, where column a has names points s...
Comments
Post a Comment