Friday, September 23, 2016

Fast Solution to Problem: Counting Macro

Counting Macro

Hello
 
I have a worksheet (Sheet1) of 1000+  rows
 and 20 columns with the following:
 
1.      Column “B” has 45 categories ( North – South – S 1234 - South East…..etc)
2.      Column “F has (Pass – Fail – Pending – Blank)
 
I need a macro to count in another sheet (Sheet2) the following
 

Category
    Pass
     Fail
     Pending
    Blank

North
No of Pass
No of Fail 
No of Pending
No of Blank

S 1234
No of Pass
No of Fail 
No of Pending
No of Blank

N 1234
No of Pass
No of Fail 
No of Pending
No of Blank

East
……etc
 
 
 

 
 
Any help is highly appreciated
 
Thank you

Keys to the Problem Counting Macro

Download Error Fixer for Free Now

No macro needed.
 Use COUNTIFS instead

Assuming on Sheet 2 Category is in cell A1

Use this in B2  =COUNTIFS(Sheet1!$B$2:$B$1500,$a2,Sheet1!$F$2:$F$1500,B$1)

You can copy this over and down for all the counts.

Change the 1500 to whatever row is the end of your data or a few rows down if you anticipate adding more data at the bottom.

Note: It is recommended that you back up your files and folders before attempting this step:

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error Counting Macro has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Another Safe way to Repair the Problem: Counting Macro:

How to Fix Counting Macro with SmartPCFixer?

1. Download SmartPCFixer. Install it on your system.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How to Fix Error - ctrl+shift+up arrow will not work in Excel 2007 SP2?,How to Resolve - Copy and paste from web page..?,Solution to Problem: Countifs drag down\/across help needed,Tech Support: Cumulative Security Update for Internet Explorer 10 for Windows 7 Service Pack 1 for x64-based Systems (KB2879017) error code 8007000D,Fast Solution to Problem: Could having a powerful computer connected to a wireless extension network cause another computer to be incapable of connecting to the network?,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment