# text 'VV' to number

#### scapiro

##### New Member
hi everyone

i have a question for you.
i will try to explaine it as good as i can.

i am making an excel document for next year so i can put in my work hours, holidays, how many hours i workd, how much holidays i have taken and so on.

now i want the sum of VV (thats the code for a vacation day where i work)

example:
http://imageshack.us/f/407/image1wk.jpg/
so i want to get the sum of the 'VV' in the colum E1 to E7.

steven

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
=COUNTIF(E1:E7,"vv")

thanx mate!

i have another question, im sorry but i am a really beginner at this

if i have 2 columns

in the first column i want to put in VD or YA (code for hours i worked over)
then in column 2 the hours that i have taken.

example => http://imageshack.us/photo/my-images/13/naamloosmq.jpg/

so i want to count of hours in different cel's of the VD and YA

thanx

Try like this

=SUMIF(A3:A5,"VD",B3:B5)

works perfect just had to change the , into ;

thank you very much!

Replies
4
Views
285
Replies
0
Views
94
Replies
2
Views
248
Replies
0
Views
100
Replies
2
Views
158

1,203,257
Messages
6,054,408
Members
444,723
Latest member
Gagan sree ram

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back