Closed

Excel formulas for progressing excel sheet

We have an excel file that keeps track of staff attendance and languages.

Each day an X is placed next to the name of the person who is working that day.

2. On the bottom of that column for that day, we need to add totals of:

a) How many sales staff total were there

b) How many sales staff per language was available

Lastly we need to clean up the sheets.

See SEPTEMBER 2017 for an example of how the column should look.

To do this we added another sheet at the end, called 'DATASOURCE'. That has all the info about which staff member speaks which languages.

I need this asap.

Attached the excel sheet to work on.

Skills: Excel, Excel Macros

See more: excel progress bar chart, excel conditional formatting data bars based on another cell, progress bar in excel, cumulative formula in excel, excel 2016 progress bar, how to create progress bar in excel 2007, excel conditional formatting percentage bar, excel running total formula, microsoft excel formulas cheat sheet, excel formulas cheat sheet, excel formulas sheet expenses, excel estimated net seller sheet, vba excel lock columns refreshing sheet, excel automatic copy database sheet, accounting excel formulas pro forma, excel macro filling excel sheet, excel formulas list, excel formulas escrow, write excel formulas, excel formulas document

About the Employer:
( 0 reviews ) Ravni Topolovac, Serbia

Project ID: #15230925

22 freelancers are bidding on average $11/hour for this job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$12 USD / hour
(187 Reviews)
7.0
TonmoyRoy111

A proposal has not yet been provided

$10 USD / hour
(199 Reviews)
6.2
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$12 USD / hour
(30 Reviews)
4.9
suyashdhoot

Hi I am a very experienced statistician and data analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done More

$25 USD / hour
(4 Reviews)
3.9
humayoonsheikh4u

Dear Sir I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas. Relevant Skills and E More

$8 USD / hour
(8 Reviews)
4.0
$12 USD / hour
(3 Reviews)
3.0
aubrey03

I am an Excel expert. My specialization is creating complex formulas and macros. You may check some of my work here: [login to view URL]

$11 USD / hour
(9 Reviews)
3.1
rameshmahala

Hello there, I would like to be considered for this job as I have good knowledge of Excel formulas and vb macros. Thanks, Ramesh

$8 USD / hour
(3 Reviews)
2.6
sadaqatali408

hi thanks for the opportunity i have read out all the information related to your staff attendance and i can use all the formulas there. why you dont knock me here now for further details . you can pay me after checki More

$12 USD / hour
(8 Reviews)
2.3
martInghia

I am Industrial Engineer graduated in 2005 with a certification as Project Manager Professional in September 2015. I have been working during the last 12+ years in industrial management in leading companies of Argenti More

$12 USD / hour
(1 Review)
1.9
nelumindralal

Hi, there is no attachment to prefer I went through the description, and this can be done within 1-2 days. I am Mechanical Engineer and frequently I solve this kind of excel tasks by automating with Macro and VBA More

$8 USD / hour
(1 Review)
0.2
sabilabry

A proposal has not yet been provided

$11 USD / hour
(0 Reviews)
0.0
$8 USD / hour
(1 Review)
0.0
ksalam7

Hi, I'm interested to work on your project. I've done a similar Excel worksheet for my current employer with Macros which can calculate Employee overtime for a month and generate reports like a calendar. I can use my More

$8 USD / hour
(0 Reviews)
0.0
Mubarekha

A proposal has not yet been provided

$16 USD / hour
(0 Reviews)
0.0
rrodriguez1407

A proposal has not yet been provided

$16 USD / hour
(0 Reviews)
0.0
arinappsol

I have familiar experience in Excel and worked on this type work daily basis on my office as it needs. I can work on this project and help you to finish this project. Thanks, Arindam.

$8 USD / hour
(0 Reviews)
0.0
EWORX

Please Allow Me To Assist You For Best. I am Expert In It. I Can Certainly Do Your Work According To Your Requirement With In Short Time. I Have More Then 9 Years Of Experience In Multiple Areas Of Computer Science and More

$12 USD / hour
(0 Reviews)
0.0
tuanthanhle

A proposal has not yet been provided

$10 USD / hour
(0 Reviews)
0.0
tcruzvany

I have 7+ years using Microsoft Excel. One of my jobs actually had me doing something very similar to the task at hand.

$11 USD / hour
(0 Reviews)
0.0