Quick question about SUMIF and COUNTIF with multiple criteria: I've attached an example. Basically, I want to include a cell in the sum if it's value is greater than the MINPRICE value and the AVAIL value for its column is equal to 1. Is there any way to write this in one cell as a concise formula, as opposed to writing seven different SUMIF and COUNTIF functions?
Thanks for any help!
Bookmarks