Cannot get INDIRECT function to work with SUMIFS

[kborgers]

Hi All, as you can see from the attached example, I am trying to have a formula that takes a sheet name from a cell in my summary sheet to pull information from the named sheet in the same workbook. I have tried a combination of the INDIRECT and SUMIF functions but I cannot get it to work. Also, rather simply, to transpose the totals in column F into a row contained within a table summary. I can of course copy and transpose the values but that would be too time consuming. I have very many sheets to summarise so any help appreciated! Apologies if this should be two separate posts – I’m sure someone will tell me if so!