| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count text values and return most common occurence | Excel Discussion (Misc queries) | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
