Pivot Table vs. CountIF

reneev

Board Regular
Joined
Apr 26, 2017
Messages
51
I have a rather large HR survey that I have to do quarterly which counts certain positions by Full Time/Part Time/Per Diem status. This survey counts these by: headcount, new hires, voluntary/involuntary terminations. Before I came along, it was all done manually. I eventually turned it into a bunch of pivot tables which have to be updated each quarter for the data source, sometimes I forget to update one and then my numbers are off (usually not found until the following quarter). Basically, all the pivots make the data file a mess and only I can read it.

I have been considering redesigning it to countIF formulas in which I feel like would be cleaner. However there would be a lot of IF values (if column is this position, if column is "bedside" or "non-bedside", if column is Full time, if column is Part time, etc...).

Before I spend an entire day redesigning, can you think of any downside to doing this? I hate to get most of the way through it and find out that it doesn't work because of something I hadn't thought about.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Given the apparent size of our workbook ... Pivot Tables are far more efficient than formulas ...

In addition ... maintenance and documentation is also far more clearer ...

Hope this will help
 

Forum statistics

Threads
1,136,314
Messages
5,675,035
Members
419,546
Latest member
RobWayCot

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
Top