Excel Formula / Find SKU's in a Report and Total Them

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. There is no formula in excel that can automatically extract all SKUs and their count. You can use CountIf formula to find count for particular SKU, but to extract all SKUs and their count automatically, you need to use macros. I can write you a macro that will create like a simple report that looks exactly like yours. If you are interested pm me and send me a sample sheet so i can take a look. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay

EXCEL/VBA expert at you service. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet formula. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

I can help you make the formula that you need, this will only take a couple of minutes! assured! Feel free to message me.

Hi, I have read the project and understand your requirement. I am a highly trained on Data Entry ,Data Analysis, Research, Web search, Web scraping, Product Add, Any Type Of Ecommerce Cart, Expert with great knowledge of Word, Excel and PDF. I also can do manual/ automated data scraping work. I take project which I can finish accurately until my client satisfied. I work for 5 Star review. I worked with some extensive and difficult email searching and lead generation jobs. Apart from this type of job I have experience in Internet research, Virtual Assistant, Business Data analysis with excel VBA formula generation etc. Kind regards, Fatima

hello i can do this job i am an expert in excel .... i know most of the formulas in excel and have done many such projects in past so please consider me for this job ...i understands in clearly thank you hope to hear from you

Hi I am an Engineering undergraduate experienced in excel for various calculations with formula,macros etc. I can help you to do this. please message to discuss further on this Thanks Note-please check my profile for past projects and reviews.

Hello there, I have read your project post and willing to do it for you. I'm MS and ACCA qualified and expert in my field. I also have expertise in Excle workings you can see in my profile portfolio or i can show you if you are interested. Kindly inbox for detailed chat of your project. Thanks

Hello there, Greetings, It's a great honor to place bid on your project. I am an experienced Asp.net developer. I have developed many websites and web services for different mobile applications. I have experience of 6+ years in development. I believe my skills would be ideal for your project. I assure you to deliver best on time and under budget. Please do share your skype id or any other contact id so that we can discuss more. Looking forward for your response. Best Regards, Anil Anjana

Hi, Just use =COUNTIF(range, criteria). Let me know though if you'd also like to look at a smarter way of working this out without the copy/paste aspect. Cheers, James