View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sirhc Sirhc is offline
external usenet poster
 
Posts: 1
Default 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!