Excel Formulas and formatting

H

Helen

how do I give a letter a value then add them up in a column ie if T=1, I want
to add up all the T's in the column but nothing else
 
B

Bob Phillips

=SUMIF(A:A,"T")*1

Thge * 1 is superfluous in this case, but if the weight is something
different you need it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
H

Helen

Hi Bob

This still doesn't seem to work. Is it because I have other numerical
figure in the column whic form another autosum?
 
B

Bob Phillips

Sorry, it should be

=COUNTIF(A:A,"T")*1


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Getting a formula to reflect added columns 10
Autonumber field in Excel that behaves the same as Access 0
VBA - exporting serial letters to single documents 0
Excel does not accept text format! 0
ASK Field Formatting 1
Newbie Help - IF Yes No Function 0
List all tables, including document structure 0

Top