Getting percentages of counts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
For me I like using the following....
=Sum(Abs([d3]="Monday"))
D3 is a field that has 7 possible responses....the days of the week.

BUT when all is said and done.....I get my say....23 people saying Sunday.
However...other days are chosen and there were 60 responses.
So my question is...
How do I get the percentage?
Originally I tried the following but it does not work.
=Sum(Abs([d3]="Monday"))/(=count([d3])
Thanks in advance for any help or guidance.
Sincerely,
Ken
 
Awesome! Thanks so much!

Duane Hookom said:
Try:
=Sum(Abs([d3]="Monday"))/Count([d3])


--
Duane Hookom
MS Access MVP
--

KenRamoska said:
Hi,
For me I like using the following....
=Sum(Abs([d3]="Monday"))
D3 is a field that has 7 possible responses....the days of the week.

BUT when all is said and done.....I get my say....23 people saying Sunday.
However...other days are chosen and there were 60 responses.
So my question is...
How do I get the percentage?
Originally I tried the following but it does not work.
=Sum(Abs([d3]="Monday"))/(=count([d3])
Thanks in advance for any help or guidance.
Sincerely,
Ken
Click to expand...
Click to expand...
 
Back
Top