| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What function to be used for the following cases
In the following example i have the dept in one coloumn and y/n criteria in other, is there any formula for me to get the total count of Y in the summary against each dept
Pls assist dept Y/N sales Y it Y production N quality N sales N it Y production Y quality Y it Y Summary sales it prod |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Cases=144 * # of Cases + Pieces | Excel Discussion (Misc queries) | |||
| IF function for two columns in diffent cases | Excel Programming | |||
| Code to Ignore Certain Cases in a Looping Function | Excel Programming | |||
| Cases within Cases | Excel Programming | |||
| GCD Function doesn't work in some cases | Excel Worksheet Functions | |||
Linear Mode
