Adding Text Values

H

hnts1982

I'm looking for some assistance in writing a simple formula and I nee
some help.

I have a spreadsheet where I'm tracking types of visits. In m
spreadsheet a:

MV is a Missed Visit = a value of 1
VC is a Visit Completed = a value of 1
DC is a Discharge Visit = a value of 1

We are going to enter these values into a row (A) and I want tota
these values based on this table. I know the solution is simple but
don't know how to write it.

Please help.

Rud
 
B

Bob Phillips

Rudy,

I am not sure I get it, but do you mean

=COUNTIF(A1:Z1,"MV")

say for missed visit?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

hnts1982 said:
I'm looking for some assistance in writing a simple formula and I need
some help.

I have a spreadsheet where I'm tracking types of visits. In my
spreadsheet a:

MV is a Missed Visit = a value of 1
VC is a Visit Completed = a value of 1
DC is a Discharge Visit = a value of 1

We are going to enter these values into a row (A) and I want total
these values based on this table. I know the solution is simple but I
don't know how to write it.

Please help.

Rudy
Click to expand...
creating financial statements
 
T

Trevor Shuttleworth

Rudy

you say Row but then say "A". Do you mean Column A ?

If so, the following formula will count occurrences of "MV" in Column A

=COUNTIF(A:A,"MV")


If you mean Rows, this formula will count the occurrences of "MV" in Row 11

=COUNTIF(11:11,"MV")

I'll leave the rest to you ...

Regards

Trevor


hnts1982 said:
I'm looking for some assistance in writing a simple formula and I need
some help.

I have a spreadsheet where I'm tracking types of visits. In my
spreadsheet a:

MV is a Missed Visit = a value of 1
VC is a Visit Completed = a value of 1
DC is a Discharge Visit = a value of 1

We are going to enter these values into a row (A) and I want total
these values based on this table. I know the solution is simple but I
don't know how to write it.

Please help.

Rudy
Click to expand...
creating financial statements
 
G

Gord Dibben

Rudy

First.....(A) is a column, not a row. Rows are 1,2,3,etc. running down.
Columns are A,B,C,etc. running across.

Second, if all values are 1 as in your example simple do a count of the
entries in column A.

Assume A1 = MV, A2 = Vc, A3 = DC

In a cell of your choosing enter this formula =COUNTA(A1:A3)

If more than this is involved, i.e. different values for different types of
visits, post back with more detail.

Gord Dibben XL2002
 
Top