Counting vacation days left

[Bruno01]

Hi there,

looking at all the posts, I am sure you can help me out ...

Starting with a spreadsheet of about 50 people, and want to track their holidays taken and left over.

I made a sheet containing
in column A their name
in column B the month
in comumn C to AG the numbers 1 to 31

for every person, I now have 1 row for each month

An example :
If "Jane" takes a full day off on April 1, I look where
"Jane" is in column A
"April" is in column B
and put a "V" in column C

If "Jane" takes half a day off on April 1, I look where
"Jane" is in column A
"April" is in column B
and put a "AMV" or "PMV" in column C

How do I count the days that Jane already took, and the days left (on a new sheet in the same workbook)?
I was thinking of
=Sum(($A$1:$A$1000="Jane")
*(If($C$1:$AG$1000="V,1,0)+If($C$1:$AG$1000="AMV,0.5,0)+If($C$1:$AG$1000="PMV,0.5,0)))

Is that correct, or is there a much easier way ?

Extra difficulty :
it is also possible that the cell contains e.g. "AMV+PMEx"
(so half a day vacation and half a day extra).
How can I check with my If-statement on part of the content of a cell ?

Thanks in advance for your assistance !!

Regards,
Bruno.

[Bruno01]

Can anybody help me out here ?

Maybe a little example to explain a bit ...
Let's say I have the following data :

°°°°°A°°°°°°°B°°°°°°°C°°°°°°°D
1 Bruno V PMV
2 Jane AMV V PMV
3 Bruno AMV
4 Jane AMV+PMEx V V
5 Jane V

I now want to count the times that, with Jane in the A column,
I have V or AMV or PMV in the whole cell or part of the cell.

So for Jane, it would be
4 times V = 4 times 1 = 4
4 times (AMV or PMV) = 4 times 0.5 = 2

Thanks for your assistance !!

[Bruno01]

Data a bit more in table format (hope this makes it more clear) :

°°°°°A°°°°°°°°°°B°°°°°°°°°°C°°°°°°°°°°D
1 °°Bruno______V________PMV
2 °°Jane______AMV________V_______ PMV
3 °°Bruno_______________AMV
4 °°Jane____AMV+PMEx_____V________V
5 °°Jane_____V