ExcelBanter - How do I use the SUM IF function with two different criteria. S.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I use the SUM IF function with two different criteria. S. (https://www.excelbanter.com/excel-worksheet-functions/16499-how-do-i-use-sum-if-function-two-different-criteria-s.html)

fish

How do I use the SUM IF function with two different criteria. S.

Jason Morin

Use SUMPRODUCT. Bob Phillips has an entire section
dedicated to it use in Excel. See:

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

HTH
Jason
Atlanta, GA

-----Original Message-----

.

All times are GMT +1. The time now is 10:12 PM.