Not quite an average...

[jediwa1ker]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Veh Type
[/TD]
[TD]Sun
[/TD]
[TD]Mon
[/TD]
[TD]Tues
[/TD]
[TD]Wed
[/TD]
[TD]Thu
[/TD]
[TD]Fri
[/TD]
[TD]Sat
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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