Formula to calculate a sum

  • Thread starter Thread starter Sirhc
  • Start date Start date
S

Sirhc

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))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum 1
Trailing 30 days sum calculation with excel 1
IF Formula to return monthly salaries 1
Finding a sum by matching two cells with the same identifier 1
Cumulative Summing 3
Sum Totaled based on Matching Identical Criteria in Worksheet 1
Still trying to average 4 worksheets and having formula problems 3
How do I average a row of 13 enries using the 8 highest in value. 2

Back
Top