ExcelBanter - How can I use SUMIF and AND to test for two conditons before summ.

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

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

- - How can I use SUMIF and AND to test for two conditons before summ. (https://www.excelbanter.com/excel-worksheet-functions/6515-how-can-i-use-sumif-test-two-conditons-before-summ.html)

Neal

How can I use SUMIF and AND to test for two conditons before summ.

Frank Kabel

Hi
use SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Neal" schrieb im Newsbeitrag
...

All times are GMT +1. The time now is 05:21 PM.