I have a user that is responsible for ordering uniforms for our sales employees. She has a workbook in Excel 2010 with about 60 worksheets, she would like to create a formula that will tell her how many Smalls, Medium, Large, XL ect to order within the WHOLE workbook. We have tried ” =countif(‘worksheetname’!cell range) we’ve multiplied that formula with each store’s information but of course were doing something wrong. Im no expert at Excel, I know the basics but this is a little out of my league as I am good with all other Office products except Excel which is why I am asking for some assistance. I have googled but couldn’t come up with anything
Could anyone help? Please let me know if you need further information. I appreciate your help, suggestions, comments ect.