Forum Discussion
Solved
Calculate the % of a Category Type "A2" from the entire spreadsheet
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: "A...
You 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)
You 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)
Awesome Hans! Thank you!