CREATE EXCEL SUMIF FORMULA (Multiple non adjacent column range)
$30-50 USD
Abgeschlossen
Veröffentlicht vor etwa 11 Jahren
$30-50 USD
Bezahlt bei Lieferung
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.
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.