Percentage Question

[Helpmepleasehahaha]

Hello,

I am trying to calculate the percentage of non-contiguous cells that contain the letter "a" out of all the selected non-contiguous cell. I am new to this site and am unsure how to upload reference images. I shall try to explain this as best i can. The target cell is Q2. i want to be able to calculate the percentage of the following cells when their value is "a", thus showing me what percentage equals "a". This sheet is for showing what vehicles my job uses and the letter "a" represents vehicles that are fully functional. Any other character or value represents that the vehicle is down for maintenance.
B8,B10,B14,B16,B20,B22,F8,F10,F12,F14,F18,F20,F22,F24,F26,F28,J8,J10,J12,J16,J18,
O8,O10,O14,O18,O22,O24,26,O28,S8,S10,S12,S14,S18,S22,S24,W8,W10,W12,W14,W16,
W18,W20,W22,W24,W26,W28

Any help will be much appreciated. Thank you.

 

[Eric W]

Welcome to the forum.

Working with non-contiguous ranges is a pain. In many cases, we can use MOD or INT functions to construct a rule that includes all of the cells, but in this case, your cells are pretty scattered. This leaves you having to individually list each cell in your formula. This should do what you want:

=SUMPRODUCT(COUNTIF(INDIRECT({"B8","B10","B14","B16","B20","B22","F8","F10","F12","F14","F18","F20","F22","F24","F26","F28","J8","J10","J12","J16","J18","O8","O10","O14","O18","O22","O24","O26","O28","S8","S10","S12","S14","S18","S22","S24","W8","W10","W12","W14","W16","W18","W20","W22","W24","W26","W28"}),"a"))/47

 

[Twollaston]

Hello,

Any help will be much appreciated. Thank you.

You could try something like this(but with your ranges filled in)
=SUM(COUNTIF(INDIRECT({"A23:A34","A3"}),"a"))/SUM(COUNTIF(INDIRECT({"A23:A34","A3"}),"<>xxxxxxxxxxxx"))

Not sure if the full value of the cell is "a" or if it only just contains "a" somewhere inside the cell