Pull data from horizontal to vertical

[jackson_hollon]

Hello,

Thanks for looking at my post. I have attached an Excel sheet here. I am working on an analysis on certain accounts. I need a formula to pull the data from the detail sheet to the summary sheet. I have the company codes on row 2 on detail sheet, but my company codes in summary sheet are on column c. I need to sum the account # 120010, 120012, and 120015. Hope my explanation makes sense.

Thanks.

[mehmetcik]

No it doesn't LOL but I will have a look.

What are the horizontal labels on the Details Sheet.

why are you reporting on three account numbers 120010, 120012, and 120015.

120012 does not exist. So why did you mention it?

[Fluff13]

How about
=SUM(SUMIF(Detail!$C$4:$C$13,{120010,120013,120015},INDEX(Detail!$F$4:$M$13,0,MATCH(C3,Detail!$F$2:$M$2,0))))

[jackson_hollon]

Fluff13,

I cannot use Array formula as my boss hates it.....

[Fluff13]

That formula does not need array entry, just the normal Enter

[jackson_hollon]

Fluff13,

I just tried your formula. It work perfectly. Many thanks.

[jackson_hollon]

mehmetcik,

The horizontal labels are the company codes. The 120012 does not exist in Jan, but will be exist in Feb.....

[Fluff13]

You're welcome & thanks for the feedback

[mehmetcik]

Formula for F3

=INDEX(Detail!$F$4:$M$13,1,ROW()-2)*$C$3 +INDEX(Detail!$F$4:$M$13,2,ROW()-2)*$C$4+INDEX(Detail!$F$4:$M$13,3,ROW()-2)*$C$5+INDEX(Detail!$F$4:$M$13,4,ROW()-2)*$C$6+INDEX(Detail!$F$4:$M$13,5,ROW()-2)*$C$7+INDEX(Detail!$F$4:$M$13,6,ROW()-2)*$C$8+INDEX(Detail!$F$4:$M$13,7,ROW()-2)*$C$9+INDEX(Detail!$F$4:$M$13,8,ROW()-2)*$C$10+INDEX(Detail!$F$4:$M$13,9,ROW()-2)*$C$11+INDEX(Detail!$F$4:$M$13,10,ROW()-2)*$C$12

[jackson_hollon]

mehmetcik,

Thanks for the help.

Jackson