Forum Discussion
Solved
Multi-conditioned revenue function
Hi, I am having a problem with a function to calculate the revenue of a certain activity. I have a list of contacts, which tells if they have attended and dined or only attended to the activity. If...
You can use VLOOKUP to find out who just attended and who attended and dined, then use COUNTIFS to return the amount you want. See the attached version.
You can use VLOOKUP to find out who just attended and who attended and dined, then use COUNTIFS to return the amount you want. See the attached version.
- Thank you for the response. I wonder still if there would be a way to circumvent using a row for the type next to payments, although for my use it actually makes more sense for it to exist, so I am using your answer.
