Elementary pivot table question that I'm just not seeing

kc.crow

Board Regular
Joined
Jul 7, 2005
Messages
75
Hello

Have what seems to be an easy pivot table question that I haven't been able to get right. Below is my data

Excel Workbook
BCD
11DivisionDataTotal
12CB_CATCount of GID437
13*Count of Completed Form2
14CIECount of GID2
15*Count of Completed Form*
16Industry AutomationCount of GID1497
17*Count of Completed Form85
18N/ACount of GID311
19*Count of Completed Form1
20TestCount of GID5
21*Count of Completed Form2
22CB_COT3Count of GID1100
23*Count of Completed Form2
24TU_DEVELOP_PRODCHECKCount of GID27
25*Count of Completed Form3
PMP-EFA Forms Completed


I am able to get the two numbers that I want to work with, but what I really need is (per distinct row header) the Count of Completed form divided by the Count of GID. So for the CB_CAT division on my example, I need to divide 2 by 437. I'm not getting this to work, though. Any suggestions?


Using Excel 2003

Thanks!
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top