Create excel formulas on worksheets

Completed Posted Sep 16, 2013 Paid on delivery
Completed Paid on delivery

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

Excel

Project ID: #4934451

About the project

12 proposals Remote project Active Sep 16, 2013

Awarded to:

koolsidz

As discussed.

$115 USD in 0 days
(149 Reviews)
6.5

12 freelancers are bidding on average $57 for this job

jaylancer43

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

$50 USD in 1 day
(903 Reviews)
9.4
Teloquence

Consider it done.

$30 USD in 0 days
(330 Reviews)
7.7
deepbluetech

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

$75 USD in 1 day
(173 Reviews)
7.4
javed1705

please check pm

$74 USD in 1 day
(108 Reviews)
6.8
DeepSyaal

Lets Start. Having a team of Professionals.

$50 USD in 2 days
(203 Reviews)
6.4
rbbahia

please read pm message

$45 USD in 3 days
(12 Reviews)
3.5
igotmail9

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

$30 USD in 2 days
(1 Review)
1.6
pachu11

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

$30 USD in 1 day
(4 Reviews)
1.3
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
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