can an array formula do this?
Posted by steve adams on May 18, 2001 5:52 AM
I've got 3 columns: one for the date, one for a transaction, & one for cost. Would like to sum a specific type of transaction for a range of dates. Have tried the following formula...it will sum the cost for the whole range, but not a specific type of transaction within the range. (?)
On a side note, will array formulas accept "BETWEEN" for the date range?