I have got a spreadsheet where a need to sum some income up, but only when they are in particular areas.
For example D6 can be OPTEACHING, OPADMIN or OPMANAGE and the income will be in V6, I need to sum this if D6 begins with OP. I don't know whether it would be easier to have another column where I identify the OP or otherwise and then do the income if this column is OP
For example D6 can be OPTEACHING, OPADMIN or OPMANAGE and the income will be in V6, I need to sum this if D6 begins with OP. I don't know whether it would be easier to have another column where I identify the OP or otherwise and then do the income if this column is OP