help with a couple functions

  • Thread starter Thread starter skaskaska
  • Start date Start date
S

skaskaska

Here is what I want to do. I have columns that have wingding symbols i
them. And I would like to total them at the bottom. So if there are 1
cells in the column and 6 have a specific wingding character, wha
would be my function to have it count how many of those characters ar
in that column.

Also, I have another column that would have one of these 5 character
(M,EX+,EX,EX-,VG). Then at the bottom I have a cell for each of thos
characters with the total of each in them. (5;M,4;EX+,etc...) Wha
would the function be to have it count that entire column for th
certain characters and give me a total?

Any help is appreciated, I cannot figure out how to accomplish this
thanks
 
Hi
you can count based on the ASCII code. e.g. something like
=SUMPRODUCT(--(CODE(A1:A100)=xx))

and replace xx with your ASCII code for the symbols of interest
 
Hi,

Not sure about your 1st Q, but to count the occurences of M, EX etc
A1=M
A2=EX+
A3=EX
A4=EX-
A5=VG

use =countif( your range, A1) counts all the "M"s

Harry
 
Well I got my 2nd question's function working (thank you), just not th
first yet. The =SUMPRODUCT(--(CODE(A1:A100)=xx)) did not work. I
sumproduct the right function for conversion of ascii? My asci
character is £ which is 156. Any other ideas? thanks
 
nevermind, I figured it out. So if any of you want to do that, use thi
function.

=COUNTIF(M1:M232,"£")+COUNTIF(M1:M232,"¨")+COUNTIF(M1:M232,"X")

and within the " " put what the character is
 
Back
Top