Let’s say you have some data like, oh I don’t know, First Name, Last Name, Gender, State, and some number. You could add up the numbers for all the males in Texas with an array formula.
=SUM((C2:C101="Male")*(D2:D101="Tx")*(E2:E101))
If you didn’t know that, go read Anatomy of an Array Formula. One of my workshop attendees had [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/05/22/include-all-in-array-formulas/
Posted
May 22 2009, 04:18 PM
by
Daily Dose of Excel