Completed

Create excel formulas on worksheets

Project # 1:

On the "COGS TOTAL" sheet (Row 27 and below each yellow column), please create a formula that gives a total quantity of cells with data in them.

Row 27: A,C,E,G,I,K,M,O,Q,S,U,W,Y,AA,AC,AE,AG,AI,AK,AM

Example:

A27 =3 by counting cells with numbers in A3:A25

Project # 2:

Using the total 's from project # 1 (Row 27 and below each yellow column), please put these totals on "PRODUCTION" sheet Row B67:O67 by finding matching the initials.

Example:

"DR" Cogs Total = 3, find "DR" in Row B1:O1 on "PRODUCTION SHEET" and insert "3" somewhere in Row B67:O67

Project # 3:

On the "VENDOR TOTAL" sheet in Row H47:Y47 (highlighted in pink), please insert the "COGS TOTAL" (Row 26 Blue Column's) by initial's

Example:

"DR" Cogs total is $1,117 (COGS TOTAL) and needs to appear somewhere in Row H47:Y47 depending on which column is "DR" (VENDOR TOTAL)

Project # 4:

On the "VENDOR TOTAL" sheet Row 76:183 and Columns H:Y (highlighted in pink) please create a VBA where I can type initials in Row 76 and infromation will appear from the "PRODUCTION" sheet

Skills: Excel

See more: find in vba, excel sheet formula, excel 2013 vba, vba e, excel w, Excel Formulas, ak, excel row column, excel 2013 formula, excel column row, formula sheet, create production sheet, vba production, column row excel, create excel formulas, matching excel, production project excel, vendor data excel sheet, vba project production, excel create

About the Employer:
( 12 reviews ) Kalamazoo, United States

Project ID: #4934451

Awarded to:

koolsidz

As discussed.

$115 USD in 0 days
(99 Reviews)
5.7

14 freelancers are bidding on average $56 for this job

Teloquence

Consider it done.

$30 USD in 0 days
(116 Reviews)
6.2
deepbluetech

Hi, I can take on the job. Let me know.

$75 USD in 1 day
(66 Reviews)
5.2
DeepSyaal

Lets Start. Having a team of Professionals.

$50 USD in 2 days
(71 Reviews)
5.3
javed1705

please check pm

$74 USD in 1 day
(22 Reviews)
4.8
jaylancer43

Excel Expert. Please check your PM for details. Thanks.

$50 USD in 1 day
(14 Reviews)
3.7
rbbahia

please read pm message

$45 USD in 3 days
(8 Reviews)
2.9
saugat1980

HI DEAR RESPECTED SIR, I AM A VERY HARD WORKING EFFICIENT HIGHLY SKILLED PROFESSIONAL. YOU CAN RELY ON ME ENTIRELY AS I HAVE DONE THESE TYPE OF JOBS PREVIOUSLY WITH HIGH DEGREE OF PERFECTION AND ACCURACY. I AM FREE NOW More

$30 USD in 3 days
(0 Reviews)
0.0
pachu11

I've read details of the proyect. I can do it. I can start right now.

$30 USD in 1 day
(0 Reviews)
0.0
cristi71000

This seems like a nice project - I'd love to work on it.

$100 USD in 3 days
(0 Reviews)
0.0
abhinay18

Easy work. Let expert handle it. I have made various macro's, so this is easy work for me.

$50 USD in 2 days
(0 Reviews)
0.0
igotmail9

Hello, I am very good at excel. I can do this easily. Please let me know.

$30 USD in 2 days
(0 Reviews)
0.0
truongbk24

please check pm for details

$30 USD in 1 day
(0 Reviews)
0.0
dieselkhan

i can do it for you

$72 USD in 3 days
(0 Reviews)
0.0