Please help me figure this calculation out Please go to http://www.diversityrus.com/help.zip for the file
% Comp. (H10) = I need to do a calculation such as: IF there is text in a cell J11:O26 count each cell as one THEN DIVIDE by the number of cells in J11:O26 which will give me the percentage.
This will be the start but there are more calculations but this will help me start it out.
Thanks
lostboyca
% Comp. (H10) = I need to do a calculation such as: IF there is text in a cell J11:O26 count each cell as one THEN DIVIDE by the number of cells in J11:O26 which will give me the percentage.
This will be the start but there are more calculations but this will help me start it out.
Thanks
lostboyca