SUMIF - multiple criteria in different columns
 

Would like to sum totals in a column based on data in two other columns - for
example - sum if col 1 = "fall" and col 2 = "VT" total col 3

SUMIF - multiple criteria in different columns
 

You probably want to use sumproduct... Take a look at this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"SUMIF Multiple Criteria in diff columns" wrote:

Would like to sum totals in a column based on data in two other columns - for
example - sum if col 1 = "fall" and col 2 = "VT" total col 3