D/All,

I have a excel fine in below format.. The first line [A As At AU AV AW] are the columns.
Channel Wk1 wk2 wk3 wk4 wk5 are the column header with data below.

A AS AT AU AV AW
Channel WK1 WK2 WK3 WK4 WK5
Abc 124 136 137 139 58
Abc 125 137 138 140 59


i want to write a formula to sum all similiar channels down for each week, hence i'm writing below formula. But now if i have multiple weeks then i will have to hardcode each column seperately,
instead i was think if i could do it in a formula which will give me this column position.

I mean if i write AS AT AU AV AW in the first row and i need the sumif formula should use indirect function accepting (AS AT AU AV AW) as parameter and return AS:AS AT:AT AU:AU AV:AV AW:AW
and return below result.

+sumif(A:A, A1, AS:AS)
+sumif(A:A, A1, AT:AT)
+sumif(A:A, A1, AU:AU)
+sumif(A:A, A1, AV:AV)
+sumif(A:A, A1, AW:AW)


Channel WK1 WK2 WK3 WK4 WK5
ABC 249 273 275 279 117

Request your help...

Rgds, Anil