Hi,

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