I have a spreadsheet (attached). I need totals to be generated by counting the number of cells of certain colour. i.e. if 10 cells are green, then it would display the number 10 in the 'total of green cells' field.
HERE ARE A FULL SET OF TASKS TO COMPLETE:
Cell B4: Needs to display the total number of GREEN cells in column E
Cell B5: Needs to display the total number of ORANGE cells in column E
Cell B6: Needs to display the total number of RED cells in column E
Cell D4: Needs to display the total sum recorded in column D (but only the cells which have GREEN next to them in column E)
Cell D5: Needs to display the total sum recorded in column D (but only the cells which have ORANGE next to them in column E)
Cell D6: Needs to display the total sum recorded in column D (but only the cells which have RED next to them in column E)
Make a pie chart to represent the 3 sets of data collected in cells B4, B5 and B6 and place next to the table.
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Mai multe
4 freelanceri licitează în medie 30$ pentru acest proiect
Hello. I have read your Bid carefully. I like VB & VBA very much. Because It was the first program I learned. Of course, now I have very high skills, many programming languages, a lot of technology and 3D technology, b Mai multe
Dear Hiring Manager! I have reviewed your requirements for your preconceived project. I'm interested in your project. I have 3 Years experience in Data Entry, Data scraping, Lead generation & Web research. I'm availab Mai multe
Quality and originality is always my focus in any project. A plagiarism and grammatical errors free project and assignment is what my client gets. I have expansive experience in academic writing and I have what it take Mai multe