Excel Formula Help Please
Closed
Tammy
-
Feb 24, 2012 at 09:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 28, 2012 at 09:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 28, 2012 at 09:12 AM
Related:
- Excel Formula Help Please
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to ignore false in excel formula ✓ - Office Software Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Feb 28, 2012 at 09:12 AM
Feb 28, 2012 at 09:12 AM
Hi Tammy,
Try this formula:
=COUNTA(C2:C4)/COUNTA(B2:B4)
Then format the cell you put the formula in as percentage.
Best regards,
Trowa
Try this formula:
=COUNTA(C2:C4)/COUNTA(B2:B4)
Then format the cell you put the formula in as percentage.
Best regards,
Trowa