| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUMPRODUCT not working
Help please,
If I am wanting to count the number of times: Damaged - Non-Shipping Related Damaged - Shipping Related Defective appear in column C and return the numbers all together, why is hte following sumproduct returning a zero? These conditions are indeed located in the column. =SUMPRODUCT((Daily_CS_Tic_Dump!C1:C1000="Damaged - Non-Shipping Related")*(Daily_CS_Tic_Dump!C1:C1000="Damaged - Shipping Related")*(Daily_CS_Tic_Dump!C1:C1000="Defective") ) Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Working time and days | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
Threaded Mode
