One way would be to use SUMPRODUCT instead. See this excellent website for
ideas, or you could post a specific example of what you are trying to do.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

tj


"victory16" wrote: