change column letter in formula with drag down

[rubertu_22]

Hello,

This is the formula
=SUM(B12+B16+B26+SUM(B27:B33)

What i've been trying to do is as I drag down the column to have the formula change to =SUM(c12+c16+c26+SUM(c27:c33) and so on.

Basically is what happens we drag to the right we get an increment on the column letter, but I want it when I drag down

 

[Jonmo1]

Try

=SUMIF(A$1:A$10,"Total*",INDEX(B$1:D$10,0,MATCH(Q2,B$1:D$1,0)))

Excel Workbook
	A	B	C	D	E	P	Q
1		Janeiro	Fevreiro	Marco		Control
2	Some tag			345		33334	Janeiro
3				234		0	Fevreiro
4	Total 1	100		579		579	Marco
5
6			2345
7		33234
8	Total 2	33234
Sheet2

 

[rubertu_22]

Thanks for the help jonmo1, you guys are awesome. Need to dig deep into excel again. Any problems, I know where to come, and who to recommend. The last post worked perfect.

Thanks again.

 

[Peter_SSs]

All the earlier resonses were trying to work without the knowledge of your headings/labels in row 1 and column A. Perhaps you can now see that giving all the information about your layout and data is likely to produce a better outcome from the forum.