sumif
 

I'd like to use a 'sumif' type cell statement, but it
needs to be based upon 2 critera, rather than 1. For
example:
column A represents the 'manufacturing month' and column B
represents the 'item' type such as "widgets" or "cogs", so
if in in a given range A1:A50 of month's, I want to count
the number of times "widgets" were manfg'd in June.

sumif
 

You can use SUMPRODUCT here

=SUMPRODUCT((A1:A100="cogs")*(MONTH(B1:B100)=6))


On Tue, 28 Oct 2003 09:43:02 -0800, "RickK" wrote:

I'd like to use a 'sumif' type cell statement, but it
needs to be based upon 2 critera, rather than 1. For
example:
column A represents the 'manufacturing month' and column B
represents the 'item' type such as "widgets" or "cogs", so
if in in a given range A1:A50 of month's, I want to count
the number of times "widgets" were manfg'd in June.