Pivot Table? over multiple columns : or other summing method?

[skyping]

All,

I am struggling with what should be an easy issue (I think!!).

I have a two worksheet workbook, where a series of dates run down column A. In columns B,I, and P, there is a description of activities (from a validation list), and in the next column to these, there is numeric validations. (See attachment)

All I need is a summary sheet (as shown) where the amounts for each activity can be seen.

I've worked on this for a while now, and I think the UK heat is getting to me (a blistering 27 degrees!!!)


Hope you can help.


Skyping

[protonLeah]

Please Login or Register  to view this content.

[skyping]

Awesome.....thank you so much. Knew it was something along those lines and using my defined ranges!!

Problem solved and reputation added.

Skyping.