ExcelBanter - SUMPRODUCT & COUNTIF

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

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

- - SUMPRODUCT & COUNTIF (https://www.excelbanter.com/excel-worksheet-functions/8026-sumproduct-countif.html)

Connie Martin

SUMPRODUCT & COUNTIF

I have this formula, which works well:
=COUNTIF(O28:O500,"=0")

However, I want to expand it to use SUMPRODUCT, but I can't get my head
around it. I want it to only count if "BAG" is in E28:E500.

Thank you muchly
Connie Martin

Frank Kabel

Hi
=SUMPRODUCT(--(O28:O500=0),--(E28:E500="BAG"))

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Connie Martin" schrieb im
Newsbeitrag ...
I have this formula, which works well:
=COUNTIF(O28:O500,"=0")

However, I want to expand it to use SUMPRODUCT, but I can't get my head
around it. I want it to only count if "BAG" is in E28:E500.

Thank you muchly
Connie Martin

Connie Martin

Thank you, Frank. That works well. I really need to take an Excel course!!

Connie

"Frank Kabel" wrote:

Hi
=SUMPRODUCT(--(O28:O500=0),--(E28:E500="BAG"))

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Connie Martin" schrieb im
Newsbeitrag ...
I have this formula, which works well:
=COUNTIF(O28:O500,"=0")

However, I want to expand it to use SUMPRODUCT, but I can't get my head
around it. I want it to only count if "BAG" is in E28:E500.

Thank you muchly
Connie Martin

All times are GMT +1. The time now is 06:00 AM.