Formula to calculate a sum

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!
 
T

T. Valko

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
IF Formula to return monthly salaries 1
Complicated Formula 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
Subtotal and IF Formula 1
Sum with multiple conditions and wildcard 2
Average/Sum formula with offset 5

Top