September 17, 2020
Category True=1, False=0
Previously my answer is =A+C+D
But they don’t want manual correction if in question 1 Category B is change to category F
Then the answer will be =A+C+D+F
Should I use vlookup/if function to sum up to total amount
October 5, 2010
I'd probably use SUMPRODUCT but I don't clearly understand your question.
What is it you want to sum, the Amount?
If so, how does F come into the equation? If your answer is A+C+D+F I don't understand what value to give F?
Please explain things again and as always, it's best to provide a workbook rather than type data into the post, which we then have to retype into a workbook.
In your explanation give examples of the expected result(s). As I said A+C+D+F is ambiguous because F has no value in the information you provided.
What exactly is the relationship between the lookup table and the question?
Why is your initial answer A+C+D? Because they have True values in your lookup table?