Not quite an average...

[jediwa1ker]

Veh Type	Sun	Mon	Tues	Wed	Thu	Fri	Sat	Total
1	2	2	2	2	2	2	2
2	1	1	2	2	2	2	2
3	2	2	2	1	1	1	1

<tbody>
</tbody>

Can anyone advise on how I could automate the below calc, we do manually at the moment but there is probably and easy formula I am overlooking.... we have a scenario where I can charge for a parking space if the space is used for 5 or more days in the week, so from the table above for Veh type 1 I would charge 2 spaces, veh type 2, 2 spaces and veh type 3, 1 space....

 

[mopp1]

Did you enter it with ctrl-shift-enter rather than just enter?

Also, it assumes first "Veh type" is in A1