Completed

CREATE EXCEL SUMIF FORMULA (Multiple non adjacent column range)

This project was successfully completed by Gooroo for $30 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $50 USD
Completed In
1 day
Total Bids
10
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online