This will count how may cells in A1:G1 have text beginning with 'v'
=SUMPRODUCT(--(LEFT(A1:G1)="v"))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"orquidea" wrote in message
...
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