VBA array Function help

[robwebber]

Hi All,

I'm struggling with a particular issue that I dont seem to be able to resolve.

in the attached workbook there is a simple time sheet arrangement whereby there is a name, which is arranged in a column, a date row across the top, and hours are inserted against each day worked.

there is a rather tricky chargeout structure which I'm trying to accommodate in a function. I've managed to do a formula but it is very large, and also needs a second row at the minute because Ive not managed to convert it into an array.

the target is to have one cell contain a total charge out value, in a column next to the column containing the name, without having to have subtotals etc

I thought I'd just about cracked the code for a single calculation (which would need a subtotal) but the function just returns a value error. i'm new to VBA and really struggling to see where I've gone wrong, and where to start to turn this into an array using the date and hours as arrays, and the name as a fixed value.

any help would be very gratefully received

regards