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.