R2497
Badges: 16
Rep:
?
#1
Report Thread starter 1 month ago
#1
Hi,

I'm having some difficulty with selecting the correct formula . I have tried countif divided by count and this has worked on one part of my spreadsheet , but not others. This has generated numbers automatically from data, and this is what I want.

I want excel to calculate the number of X in a column (count not sum) , divided by total count of cells in that column (x 100), so I want a percentage.

Please could somebody advise? Many thanks
0
reply
davros
  • Study Helper
Badges: 16
Rep:
?
#2
Report 1 month ago
#2
(Original post by R2497)
Hi,

I'm having some difficulty with selecting the correct formula . I have tried countif divided by count and this has worked on one part of my spreadsheet , but not others. This has generated numbers automatically from data, and this is what I want.

I want excel to calculate the number of X in a column (count not sum) , divided by total count of cells in that column (x 100), so I want a percentage.

Please could somebody advise? Many thanks
What was the actual formula you were using? If it worked on one part of the sheet it should work elsewhere, unless there's some subtlety in the data.
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Do you have the space and resources you need to succeed in home learning?

Yes I have everything I need (251)
57.18%
I don't have everything I need (188)
42.82%

Watched Threads

View All