Excel Forum

Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula

See how to check a range of cells for codes and then add associated numbers. See a SUM array formula and a COUNTA / SUMPRODUCT / SUMIF function formula.
See formula from barry houdini from Mr Excel Message Board.

Got a Question? Ask it Here in the Forum.