|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 15th 12, 05:28 AM
|
|||
|
|||
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 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula for Cases=144 * # of Cases + Pieces | Inventory Formula | Excel Discussion (Misc queries) | 2 | December 29th 09 09:09 PM |
| IF function for two columns in diffent cases | pt_lily | Excel Programming | 4 | October 25th 07 12:32 AM |
| Code to Ignore Certain Cases in a Looping Function | [email protected] | Excel Programming | 4 | September 7th 07 10:38 PM |
| Cases within Cases | mtm4300 via OfficeKB.com | Excel Programming | 7 | February 19th 06 01:42 AM |
| GCD Function doesn't work in some cases | GCD_Dilemma | Excel Worksheet Functions | 5 | November 8th 04 08:18 PM |
Linear Mode
