Calculating half days in attendance spreadsheet

Hi
I am using the excel spreadsheet template and would like to assign a value for a half day, this is the formula I have now in the vacation column

=COUNTIF($B6:$AF6,"V")

I would like V to be designated as 1 and v as 1/2

Can anyone please help?

Thank you

I tried that. it stated array formulas are not valid in merged cells.
Thanks

Can you unmerge cells (as they more often than not cause the problem you experienced)?

Try

=SUMPRODUCT(--(ISNUMBER(FIND("v",A6:AF6)))*0.5+--(ISNUMBER(FIND("V",A6:AF6))))

Ok, so I unmerged the cells, and the formula worked however, it is not counting v as .50 a day, both v & V are counting as 1.

Note that your range is $B6:$AF6 but JohnTopley's range is A6:AF6. Could that be the problem?

Works OK for me as does "6StringJazzer" formula with range B6:AF6 (or any range!). If you are still having problems, post a sample file.

Grrr! why isn't this working for me. I tried both, fixing the cell range.
I have tried both formulas in the attached and they are still counting both V & v as 1
I tried attaching the spreadsheet but it just keeps spinning
Feeling frustrated

I tried this
=SUMPRODUCT(--(ISNUMBER(FIND("v",B6:AF6)))*0.5+--(ISNUMBER(FIND("V",B6:AF6))))

and this in another cell

=SUM(IF(EXACT("V",$B8:$AF8),1,0))+0.5*SUM(IF(EXACT("v",$B8:$AF8),1,0))

I didn't press enter, but Ctlr sft enter

I tried adding the attachment but when I tried adding it, it just kept spinning and spinning.
I also tried the sumproduct one with just enter and it didn't work either.

Put your data into file from post #8 and see what results you get.

I have re-attached said file with no problem so don't understand the "Spinning"

TW33 here are detailed instructions for attaching. It is a bit clunky compared to other sites. Last line is a link to screen shots.

To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Here are step-by-step instructions with screen shots