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

More than one variable for Countif 14
Copy line if 21
Copy entire row from another sheet onto first sheet if a unique text matches 1
sum a set of cells based on comparing a different set of cells 3
vlookup count? 2
using an IF or AND function to get next largest value in list 1
Count Non-Blank Values in a Table but only for a range 3
Count if dates meet certain criteria 10

Top