Find Jobs
Hire Freelancers

CREATE EXCEL SUMIF FORMULA (Multiple non adjacent column range)

$30-50 USD

Selesai
Disiarkan lebih dari 11 tahun yang lalu

$30-50 USD

Dibayar semasa penghantaran
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.
ID Projek: 4238962

Tentang projek

8 cadangan
Projek jarak jauh
Aktif 11 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
**I HAVE YOUR MACRO Sir! (Formula is not good enough)** See PM Please! IT just waits for you. THANKS!
$30 USD dalam 0 hari
5.0 (16 ulasan)
4.2
4.2
8 pekerja bebas membida secara purata $33 USD untuk pekerjaan ini
Avatar Pengguna
easy job consider it done
$30 USD dalam 0 hari
4.9 (15 ulasan)
3.8
3.8
Avatar Pengguna
More than 10 years experience in Excel and VBA.
$34 USD dalam 1 hari
4.9 (7 ulasan)
3.8
3.8
Avatar Pengguna
Hi - Please check your PM for details.
$31 USD dalam 1 hari
5.0 (7 ulasan)
3.3
3.3
Avatar Pengguna
"We exist in world's Top 10 Virtual Assistant and Data Entry companies"
$40 USD dalam 1 hari
5.0 (4 ulasan)
2.8
2.8
Avatar Pengguna
Hi, Formula expert here. Check you PM for details.
$35 USD dalam 0 hari
5.0 (5 ulasan)
2.5
2.5
Avatar Pengguna
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 dalam 0 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera TURKEY
Istanbul, Turkey
5.0
11
Kaedah pembayaran disahkan
Ahli sejak Okt 14, 2012

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.