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 |