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?