Excel Forum



Excel Magic Trick 602: SUMIF Does Lookup? Total Sales Array Formula w 1 Criteria SUMIF Function


See how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database. See the SUMPRODUCT and SUMIF functions together.





Got a Question? Ask it Here in the Forum.