ExcelBanter - COUNTIF with additional qualifiers?

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

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

- - COUNTIF with additional qualifiers? (https://www.excelbanter.com/excel-worksheet-functions/138253-countif-additional-qualifiers.html)

Larry[_2_]

COUNTIF with additional qualifiers?

I like the COUNTIF function but want to include the ability to expand
the "match" criteria to include data in other columns. Possible?

Max

COUNTIF with additional qualifiers?

One way is to use SUMPRODUCT
An excellent resource on SD is Bob Phillips' page at:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Larry" wrote in message
oups.com...
I like the COUNTIF function but want to include the ability to expand
the "match" criteria to include data in other columns. Possible?

Larry[_2_]

COUNTIF with additional qualifiers?

On Apr 8, 12:30 am, "Max" wrote:
One way is to use SUMPRODUCT
An excellent resource on SD is Bob Phillips' page at:http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--

Perfect! Exactly what I was after. Wish I'd known this 4 years ago!

Max

COUNTIF with additional qualifiers?

It's never too late, Larry <g !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Larry" wrote
Perfect! Exactly what I was after. Wish I'd known this 4 years ago!

All times are GMT +1. The time now is 04:09 AM.