D
DUKE
HOW DO I ADD NON-NUMERIC VALUES?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Without shouting (i.e., using ALL CAPS), please explain what you mean by
"add non-numeric values".
Addition normally requires that values be numeric.
"add non-numeric values".
Addition normally requires that values be numeric.
R
Ron Coderre
Can you give examples of the "non-numeric values"?
(btw, we avoid typing in all capitals
in the newsgroups.....it indicates shouting)
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
(btw, we avoid typing in all capitals
in the newsgroups.....it indicates shouting)
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
G
Gary''s Student
You need to first convert them into numbers.
B
Bernard Liengme
Do you mean COUNT?
=COUNTIF(A1:A20,"cat") will count how may times a cell in A1:20 has the
value "cat"
best wishes
=COUNTIF(A1:A20,"cat") will count how may times a cell in A1:20 has the
value "cat"
best wishes