mardi 3 août 2021

How to get total number of row entry that is grouped by rows on google sheets

I have a table of data that is formatted like this

enter image description here

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