Sum If
Thanks, it worked
"muddan madhu" wrote:
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
|