Take a look here for a great explanation of the SUMPRODUCT function, as well
as examples of it's use.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Anonymous" wrote in message
...
Does anyone know to create multiple ranges and criteria within the SUMIF
worksheet function?