Vlookup or sumifs formula

[Sheap]

Reference table

Category True=1, False=0

A 1

B 0

C 1

D 1

E 0

F 1

G 0



Question

Category Amount

A 60

B 90

C 10

D 80

E 60

Total X=?



Previously my answer is =A+C+D

But they don’t want manual correction if in question 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

 

[Peter Bartholomew]

SUMIFS is the most appropriate function for the task
= SUMIFS(Value, Criterion, 1)
There are circumstances where breaking the formula down to
= SUM( IF(Criterion, Value) )
can be useful. This may be the case if the Values are returned by a formula rather than being read from a range as you have described.

 

[bosco_yip]

Cross-post at :

https://www.reddit.com/r/excel/comments/iudhkb

Please don't cross-posting and read the forum rule for new user:
https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Regards