Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |