I have a spreadsheet with headings for the months in cells K3 (JAN) thru V3
(DEC)and values in the rows below. I am trying to come up with a formula
that will allow me to plug a month in J3 and have it SUM the corresponding
balance for the year (i.e. I enter MAY and the formula will return the SUM of
O3 (MAY) thru V3 (DEC) for each row.

Any help would be greatly appreciated!

Try this...

Headers in row 3, data to sum in row 4...

=IF(J3="","",SUM(V4:INDEX(K4:V4,MATCH(J3,K3:V3,0)) ))

--
Biff
Microsoft Excel MVP


"Sirhc" wrote in message
...
I have a spreadsheet with headings for the months in cells K3 (JAN) thru V3
(DEC)and values in the rows below. I am trying to come up with a formula
that will allow me to plug a month in J3 and have it SUM the corresponding
balance for the year (i.e. I enter MAY and the formula will return the SUM
of
O3 (MAY) thru V3 (DEC) for each row.

Any help would be greatly appreciated!