In a previous blog post Sum adjacent values using multiple lookup text values in a column in excel I created a formula to sum specific values using two or more conditions in a column.
In this blog post I will create a formula to sum specific values using two or more conditions in a range containing more than one column.
Array formula in E18:
What is named ranges?
How to increase the number of search criteria
Change the named range search_tbl.
Download excel example file
Sum adjacent values using multiple lookup values in a range.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Counts the number of cells within a range that meet the given condition
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Adds all the numbers in a range of cells