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 |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com