COUNTIF problems

F

Frank Kabel

Hi
try
=COUNTIF('Calls logged'!I2:I1000, "A1*")
-----Original Message-----
i have a column of data containing :
A1. what is a social worker?
B4. employment and study
C2. change to details
A7. when should i register?
C1. PR training
A7. when should i register?

basically it is for a call log database... and the topic
Click to expand...
of discussion for each call is recorded and entered into
this database via a user form.
all I want to do is add up the total amount of A1's,
Click to expand...
A2's, A3's, Bx's, Cy's, Dz's etc etc etc...
 
Top