is there a formula for this

[dpaton05]

I have a table with several broad headings at the top. Each of those headings have 3 sub headings. Is there a formula to access each column as all I can think of are a few if statements? (I don't know a lot about excel)

 

[Yongle]

Q1 Does your table look like this?

Sub2	Sub2	Sub2

<colgroup><col style="width:48pt" width="64" span="9"> </colgroup><tbody>
[TD="class: xl63, width: 192, colspan: 3"] HeaderA
[/TD]
[TD="class: xl63, width: 192, colspan: 3"] HeaderB
[/TD]
[TD="class: xl63, width: 192, colspan: 3"] HeaderC
[/TD]

[TD="class: xl66"]Sub1[/TD]

[TD="class: xl67"]Sub3[/TD]
[TD="class: xl66"]Sub1
[/TD]

[TD="class: xl67"]Sub3
[/TD]
[TD="class: xl66"]Sub1
[/TD]

[TD="class: xl67"]Sub3
[/TD]

[TD="class: xl68"]a1[/TD]
[TD="class: xl69"]b1[/TD]
[TD="class: xl70"]c1[/TD]
[TD="class: xl68"]d1[/TD]
[TD="class: xl69"]e1[/TD]
[TD="class: xl70"]f1[/TD]
[TD="class: xl68"]g1[/TD]
[TD="class: xl69"]h1[/TD]
[TD="class: xl70"]i1[/TD]

[TD="class: xl68"]a2[/TD]
[TD="class: xl69"]b2[/TD]
[TD="class: xl70"]c2[/TD]
[TD="class: xl68"]d2[/TD]
[TD="class: xl69"]e2[/TD]
[TD="class: xl70"]f2[/TD]
[TD="class: xl68"]g2[/TD]
[TD="class: xl69"]h2[/TD]
[TD="class: xl70"]i2[/TD]

[TD="class: xl68"]a3[/TD]
[TD="class: xl69"]b3[/TD]
[TD="class: xl70"]c3[/TD]
[TD="class: xl68"]d3[/TD]
[TD="class: xl69"]e3[/TD]
[TD="class: xl70"]f3[/TD]
[TD="class: xl68"]g3[/TD]
[TD="class: xl69"]h3[/TD]
[TD="class: xl70"]i3[/TD]

[TD="class: xl68"]a4[/TD]
[TD="class: xl69"]b4[/TD]
[TD="class: xl70"]c4[/TD]
[TD="class: xl68"]d4[/TD]
[TD="class: xl69"]e4[/TD]
[TD="class: xl70"]f4[/TD]
[TD="class: xl68"]g4[/TD]
[TD="class: xl69"]h4[/TD]
[TD="class: xl70"]i4[/TD]

[TD="class: xl71"]a5[/TD]
[TD="class: xl72"]b5[/TD]
[TD="class: xl73"]c5[/TD]
[TD="class: xl71"]d5[/TD]
[TD="class: xl72"]e5[/TD]
[TD="class: xl73"]f5[/TD]
[TD="class: xl71"]g5[/TD]
[TD="class: xl72"]h5[/TD]
[TD="class: xl73"]i5[/TD]

</tbody>

Q2 Is it an Excel Table or tabulated data? -it is an Excel table if Table Tools menu becomes available when you click on any cell in the table

 

[dpaton05]

Not only like that, but it also had two rows of headings down the left. I realised this was a terrible way to design a table and split it into 11 seperate tables.

 

[dpaton05]

I am getting really confused and am not real sure what to do. These are the two headings from the top https://www.screencast.com/t/l4Vw9W39GvN and here are the two headings from the side https://www.screencast.com/t/7kVVeppUFC. I thought that splitting them would be the best way to go but now I have 11 smaller tables and i'm not really sure how splitting them is meant to make it easier.

 

[Legacy 421546]

What is your goal? Access the data cells? All cells?

 

[dpaton05]

This is my table https://www.screencast.com/t/3KW9dkxB65A I am trying to get the price for an hour of youth work support from this table https://www.screencast.com/t/j4khCrIjxCL. This is my attempt at a formula to go in the field that has the total price but it won't work. Where have i gone wrong, or is there a better way to do this?

=IF(OR(ISBLANK(B13),ISBLANK(D13),ISBLANK(E13),ISBLANK(F13)),0,(IF(D13=Services!A3,INDEX(YWS_Max_pay_1hr,MATCH(C13,Table15[Column1],0),MATCH($E$4,X61:Z61,0)))))

 

[dpaton05]

 

[dpaton05]

I am at work at the moment and I cannot install a program to allow me to upload an image link but I will upload an image when I get home.

 

[dpaton05]

Basically, there is two rows of headings at the top and two rows of headings at the side. Could I use the SUMIF formula to add up all the bits?

 

[dpaton05]

This is where my data is coming from. https://www.screencast.com/t/AihsVKnIe9