Yes I am Bob, but I do not know how to attach a sample spredsheet of
what I am trying to do. Appologies for my ignorance.
I include the contents of my text box.
Thanks for your interest.:-

In columns X to AC I am adding values from column G according to
category with reference to column D. That part is OK I think, but then
I want to further drop these totals according to category held in row 3
T to AB with reference to the drop down list in column O. If I get the
principle right I can then make it more user friendly. Can anyone help?
What am I doing wrong in cell Z8?