I tried searching for the solution but cannot seem to find exactly what I need.
I am tring to sum all the values in column a where the associated volue in column b is one of five values.
Here is the regular sumif
=SUMIF(A:A,1,B:B)
I woudl like it to add the value if it is equal to 1,4,6,9,19. Not sure how to do that. Do I need to nest another function?
Bookmarks