I have a table of data that is formatted like this
and i would like to extrapolate how many ASSIGNMENTS, PROJECT, and PERMITS total on all the engineers.
Im having problem because this does not really deal with numbers so no mathematical formula i cant think of will work.
Here is a sheet link of the image above.
Here is my idea of doing it but i have no idea how to code this into a formula on excel.
The formula will look for the key word, assignment, project, or permit and will then check if the next 2 column have contents in them if so then it is a plus 1, if the cell below the keyword(assignment,proect,or permit) is empty check if there is contents to 2 column beside the empty cell if empty then stop, if there is plus 1, if a plus 1 check again for an empty cell below that one rinse and repeat.
Aucun commentaire:
Enregistrer un commentaire