Formula to calculate a sum
 

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!

Formula to calculate a sum
 

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!