Beranrd:

For some reason I keep getting an error when typing the formula below. I
already made sure I have all the parenthesis. Do you have any idea what I am
doing wrong?


"Bernard Liengme" wrote:

If all cells have entries in the form LetterDigit(s):
a) if the number is always a single digit:
=SUMPRODUCT(--(LEFT(A1:G1)="v"),--RIGHT(A1:G1,1))
b) if the number can be greater than 9
=SUMPRODUCT(--(LEFT(A1:G1)="v"),--MID(A1:G1,2,255))
I will try to find for the case when some cells are empty or contain only
text
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"orquidea" wrote in message
...
Thanks for your answer but I want to add the values, the result should be
4
(v3, V1)


"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