Here is my question:
How to add selective items in a cell?
Tried using SUMIF, OFFSET functions with no luck. (SUMIF(range,COUNTIF(range, "10"), OFFSET(range,1,0))
Please advise what functions can be used to solve this problem ?
Thank you for your time.
SUM of cells next to Code 10=100+200+400 =700
SUM of cells next to Code 20=250+50 =300
Bookmarks