Z
zy1972
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
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