COUNTIF with additional qualifiers?

[Larry]

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

 

[Max]

One way is to use SUMPRODUCT
An excellent resource on SD is Bob Phillips' page at:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Larry]

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]

It's never too late, Larry <g> !