Good evening everyone,
I would like some help with a formula if anyone could assist. I have searched a number of forums and not had any luck!
I have created a staffing list with various columns of information. On a separate tab, I would like to count how many times a name appears in column 'E' and in P column how many times it says 'yes'. I want to check the name and yes to appear for it to count. I have tried =COUNTIF(Staff!E:E,Complete!C3)+COUNTIF(Staff!P3:P500,"Yes")
Plus other variations. I think I'm almost there but need some help!!
Also, I have done a custom sort for two columns that needs refreshing
I have seen the new =SORT but it is not showing on my version. Is there something else that would complete this sort as date is added?
Thanks for any help
I would like some help with a formula if anyone could assist. I have searched a number of forums and not had any luck!
I have created a staffing list with various columns of information. On a separate tab, I would like to count how many times a name appears in column 'E' and in P column how many times it says 'yes'. I want to check the name and yes to appear for it to count. I have tried =COUNTIF(Staff!E:E,Complete!C3)+COUNTIF(Staff!P3:P500,"Yes")
Plus other variations. I think I'm almost there but need some help!!
Also, I have done a custom sort for two columns that needs refreshing
I have seen the new =SORT but it is not showing on my version. Is there something else that would complete this sort as date is added?
Thanks for any help