LOOKUP and SUM IN EXCEL

Crispo Mwangi | 7-Aug-16 | Leave a Comment

Array fomulas comes in handy when you want to lookup and sum large amount of data. Array formulas replaces multiple normal formulas,performs multiple calculations and returns a single value as a result. For example using ¬†below Main sales data in Quantity and a lookup price table, Calculate total sales for customer Brosina Hoffman?   There […]