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.