Excel formula to calculate on excel with letters?
could somebody provide me with the excel formula to generate a spreadsheet which shows me tips on how to calulate some sort of work rota.employing letters.had it before nonetheless a handle manager erased my laptop and all files (yes i needs to have backed up) possessed it when E with regard to earlys and also L to get lates and at the bottom it would certainly tell me if i did not need enough Es or maybe Ls (or also many) from the constant connected with 8.get tried the formula wizard but zero joy.
sounds like you’ll use your COUNTIF() function
so if A1 to be able to A9 acquired E’s or even L’s
you’ll use a new formula lkike this
=COUNTIF(A1:A9, “E”)
you would like to combine it considering the IF() function to measure for more than and within.
in addition to that…inquire around.maybe people emailed a vintage version of the file to be able to someone.contain the person give it to you as well as update it.
Leave a Reply
You must be logged in to post a comment.