Count values only if matches and return on another worksheet

C

candacer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Non-Blank Values in a Table but only for a range 3
Count if dates meet certain criteria 10
SUM(IF()) array formula in a separate workbook and multiple worksh 5
Count Unique Values in 1 Column based on Date Range in another Column 28
Conditional Count Formula 2
how to show whether 3 cells within a row match 3 cells in another 3
array and countif help! 7
Can "countifs" be utilized to return a count of unique values? 1

Top