Source table as posted assumed in A1:F4
Input placed in B7: 3
In B8: =SUM(OFFSET(B2,,,,B$7))
Copy B8 down to B10 to return required results for Sales, Mkt, Adm
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zy1972" wrote:
If I have the following schedule (on bottom), I have another cell to input
numbers (1-12), Is there a formula could automatically summary each function
(sales, mkt etc) YTD when I update the input number.

I tried sumif and indirect functions, but sumif can only take on column.

i.e. if I input 3 (for March)

I should see:

Sales: 12, Mkt:16, admin: 11




Jan Feb Mar Apr ... Dec
Sales 1 5 6 8 11
Mkt 3 5 8 0 2
Adm 1 4 6 7 1

Thanks,

Glenn