Count values only if matches and return on another worksheet
 

I need a formula that will count ONLY the number of SKU's that have an
approved date listed in one column and ONLY for "Team A" in another column. I
need this returned on another worksheet. So in my example given below I'd
have only one counted & returned. Does this make sense? Thanks in advance!

Example:

SKU Approved Date Assigned To
X12-20854 5/12/2008 Team D
X51-57543 Team A
X72-22044 Team B
X88-89180 4/11/2008 Team A

Count values only if matches and return on another worksheet
 

try this
=SUMPRODUCT(--(M3:M22="a"),--(L3:L220))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"candacer" wrote in message
...
I need a formula that will count ONLY the number of SKU's that have an
approved date listed in one column and ONLY for "Team A" in another
column. I
need this returned on another worksheet. So in my example given below I'd
have only one counted & returned. Does this make sense? Thanks in advance!

Example:

SKU Approved Date Assigned To
X12-20854 5/12/2008 Team D
X51-57543 Team A
X72-22044 Team B
X88-89180 4/11/2008 Team A

Count values only if matches and return on another worksheet
 

Wow! Thank you so much! I have been toiling with this all day!

"Don Guillett" wrote:

try this
=SUMPRODUCT(--(M3:M22="a"),--(L3:L220))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"candacer" wrote in message
...
I need a formula that will count ONLY the number of SKU's that have an
approved date listed in one column and ONLY for "Team A" in another
column. I
need this returned on another worksheet. So in my example given below I'd
have only one counted & returned. Does this make sense? Thanks in advance!

Example:

SKU Approved Date Assigned To
X12-20854 5/12/2008 Team D
X51-57543 Team A
X72-22044 Team B
X88-89180 4/11/2008 Team A

Count values only if matches and return on another worksheet
 

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"candacer" wrote in message
...
Wow! Thank you so much! I have been toiling with this all day!

"Don Guillett" wrote:

try this
=SUMPRODUCT(--(M3:M22="a"),--(L3:L220))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"candacer" wrote in message
...
I need a formula that will count ONLY the number of SKU's that have an
approved date listed in one column and ONLY for "Team A" in another
column. I
need this returned on another worksheet. So in my example given below
I'd
have only one counted & returned. Does this make sense? Thanks in
advance!

Example:

SKU Approved Date Assigned To
X12-20854 5/12/2008 Team D
X51-57543 Team A
X72-22044 Team B
X88-89180 4/11/2008 Team A