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.

Taidot: Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 8 arvostelua ) Istanbul, Turkey

Projektin tunnus: #4238962

Myönnetty käyttäjälle:


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

$30 USD 0 päivässä
(9 Arvostelua)

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

$30 USD 1 päivässä
(57 arvostelua)

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 1 päivässä
(59 arvostelua)

easy job consider it done

$30 USD 0 päivässä
(13 arvostelua)

More than 10 years experience in Excel and VBA.

$34 USD 1 päivässä
(5 arvostelua)

Hi - Please check your PM for details.

$31 USD 1 päivässä
(6 arvostelua)

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

$35 USD 0 päivässä
(5 arvostelua)

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

$31 USD 2 päivässä
(0 arvostelua)

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

$40 USD 1 päivässä
(0 arvostelua)

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 0 päivässä
(0 arvostelua)