Creating a Formula

Copper Contributor

I need help in creating a formula. 


Case Worker: Luna, Kris, Penny

Individuals applying: A,K (Adults, Kids)

For every application received, it is assigned to one of the case workers. They then track how many kids or adults (A, K) applying. How do I create a formula to show how many individuals applying for each cases/application assigned to each case workers?

Example: Kris wants to calculate the total individuals applying that was assigned to herself. In order to do that, she would have to manually calculate the total. How can Kris create a formula that every time, she enters the numbers of apps and individuals applying, the system will calculate for her?

1 Reply
best response confirmed by KMay03 (Copper Contributor)


For example:


In H2:


And in H3: