copy the formula and paste it in your worksheet now hit F2 or double
click on the cell | you will see the formula in the cell , now hit
ctrl + shift + enter
you will see the curley brackets at the begining & at the end of the
formula.



On Nov 19, 12:06*am, orquidea
wrote:
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