Oct 04 2022 06:16 AM - edited Oct 04 2022 06:17 AM
Hello Professionals,
My question appears to be a complicated one, but I am hoping someone can provide me with a solution.
I am compiling a spreadsheet with different categories (i.e. name: "A2") in column D.
How do I find the % of all "A2's" in column D, for the entire spreadsheet?
For example, if there are twenty"A2" in column D, and the total number of items are 80, how do I produce a value of 25%?
Thanks in advance!
Oct 04 2022 06:38 AM
SolutionYou can use
=COUNTIF(D:D,"A2")/COUNTA(D:D)
and format the cell with this formula as a percentage. If you want to exclude one or more header rows: let's say your data begin in row 4, and will never extend below row 1000.
=COUNTIF(D4:D1000,"A2")/COUNTA(D4:D1000)
Oct 04 2022 07:34 AM
Oct 04 2022 06:38 AM
SolutionYou can use
=COUNTIF(D:D,"A2")/COUNTA(D:D)
and format the cell with this formula as a percentage. If you want to exclude one or more header rows: let's say your data begin in row 4, and will never extend below row 1000.
=COUNTIF(D4:D1000,"A2")/COUNTA(D4:D1000)