SUM values in cells using a LOOP and CASE

[TheSleeper]

Hi All :0)

I am creating a worksheet that counts number of accidents pr. year for a given month, and it has been working perfectly until now.

I am at a point where i need to SUM values in the cells ... so that i can display how many sickdays there is, for that year in that given month!

I am pretty new to VBA and i have run out of ideas.

For counting accidents pr. year i have used this code which works very well! Now i just have to use SUM instead of counting + 1.

Can i use the same code for SUM or do i have to do something different?

I need to sum the values in the cells on my DATA sheet:

Please Login or Register  to view this content.

VBA:

Please Login or Register  to view this content.

[TheSleeper]

Im looking for a soultion on how to implement SUM in the above LOOP!

Any kinda of help would be greatly appreciated