In Progress

CREATE EXCEL SUMIF FORMULA (Multiple non adjacent column range)

We need you to create SUMIF formulas for HR/Accounting Purposes. Please review the attached excel file before bidding on the project.

The Assignment includes:

--- Create FORMULAS to calculate the total hrs and total cost indicated with "???" above.

--- Total hrs and total cost of each project needs to be calculated based on the table at the "workhours" tab.

--- Note that the workhours tab should stay as is. It is a sample table for a bigger actual table that we use.

--- The formula needs to be dynamic, since the workhours table can grow so easily.

--- The hours column of each project will always be the FIRSTcolumn next to the project name

--- The cost column of each project will always be the SECOND column next to the project name

--- Please see the sample formula at the sample tab

--- Note that the workhours tab should stay as is. It is a sample table for a bigger actual table that we use.

Skills: Excel

See more: sumif excel sample, sumif adjacent column, cost accounting formulas, excel sumif non adjacent range, excel accounting formulas sumif, multiple sumif excel sample, sample formula sumif excel, excel sumif sample, formula it, sumif assignment, project cost accounting, Excel Formulas, Excel accounting, Column, bidding formulas, accounting excel sample, excel 2013 formula, excel cost accounting, cost accounting excel, need formula, non accounting accounting assignment, create excel formulas, create tab excel, create accounting, excel create

About the Employer:
( 8 reviews ) Istanbul, Turkey

Project ID: #4238962

Awarded to:

Gooroo

**I HAVE YOUR MACRO Sir! (Formula is not good enough)** See PM Please! IT just waits for you. THANKS!

$30 USD in 0 days
(9 Reviews)
3.7

10 freelancers are bidding on average $32 for this job

bharanisrihari

Hello, Excel expert here. It's an easy job. Please check PM for details. Thanks!

$30 USD in 1 day
(57 Reviews)
6.3
mrbrave

Lets start....I will develop and provide you a sum-if like more advanced [url removed, login to view] will accept multiple ranges when calculating.

$30 USD in 1 day
(59 Reviews)
5.2
vikashgadia

easy job consider it done

$30 USD in 0 days
(13 Reviews)
3.5
adim

More than 10 years experience in Excel and VBA.

$34 USD in 1 day
(5 Reviews)
3.3
edatawiz

Hi - Please check your PM for details.

$31 USD in 1 day
(6 Reviews)
3.2
Abikris

Hi, Formula expert here. Check you PM for details.

$35 USD in 0 days
(5 Reviews)
2.5
wickrasoft

Hi there, Please see my private message and get back to me. This Can be done. Wickrasoft

$31 USD in 2 days
(0 Reviews)
0.0
Evs1

"We exist in world's Top 10 Virtual Assistant and Data Entry companies"

$40 USD in 1 day
(0 Reviews)
0.0
ldillow

Good evening! I have been working with Excel for years and can do this project this evening if desired. I have sent you some additional details about my experience via PMB.

$30 USD in 0 days
(0 Reviews)
0.0