Thanks for your answer. Please tell me when do I hit CRTL + SHIF + ENTER. I
typed the formula but I get "#Value" error. Do you have any idea what I am
doing wrong?

"muddan madhu" wrote:

try this ( use ctrl + shift + enter )

=SUM(--(IF(LEFT(C2:E2)="v",RIGHT(C2:E2,1))))

On Nov 18, 10:56 pm, orquidea
wrote:
Hi:

I have a calendar in a spreadsheet. I record by week the vacations days and
sick days. In cell A I would like to get the sum of all the cells that start
with "v". In the example the total is 4. How could I write a formula which
calculate this?
Could anyone help me please?
JANUARY
Cell A 1 - 7 8 - 14 15 - 21
Total V Cell C5 Cell D5 Cell E5
4 v3 s2 v1
Thanks,
Orquidea