Main Profile

At A Glance

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.
Length: 07:21

Contact

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

Want more info about Excel Magic Trick 602: SUMIF Does Lookup? Total Sales Array Formula w 1 Criteria SUMIF Function? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question