V
vivi
Hi there
I hope someone can help me. I try to use sumproduct to sum up the data on my
data sheet as follow:
=SUMPRODUCT(--(A6='Actual FTE(£)'!A8:A80),--('Phased Costs By
Deparments'!B4='Actual FTE(£)'!M6:AV6),('Actual FTE(£)'!M8:AV80))
However, it doesn't work!!! and I am not sure why...
Basically, I have a data sheet which contains Jan'08-Dec'10 as the column
header, then on the side, the row headers are the functions for my company:
Function Resource Jan'08 Feb'08 Mar'08
BTS Allen 500 600 650
BTS Matthew 200 700 900
Finance Lisa 1000 900 700
Actuarial Vivian 150 450 650
Legal Wilson 250 100 150
Complian Darren 300 560 500
Complian Rosa 400 240 300
My report only show the monthly figures for a year, i.e. 12 columns.
Therefore when I sum up for each function, I also need to know which months
should be summed up for and calculate on my report.
I hope I explain myself clearly, if not please let me know...I think using
sumproduct is the solution but not sure why it is not working...please
someone help!!!!
Thansk a lot in advance
Vivi
I hope someone can help me. I try to use sumproduct to sum up the data on my
data sheet as follow:
=SUMPRODUCT(--(A6='Actual FTE(£)'!A8:A80),--('Phased Costs By
Deparments'!B4='Actual FTE(£)'!M6:AV6),('Actual FTE(£)'!M8:AV80))
However, it doesn't work!!! and I am not sure why...
Basically, I have a data sheet which contains Jan'08-Dec'10 as the column
header, then on the side, the row headers are the functions for my company:
Function Resource Jan'08 Feb'08 Mar'08
BTS Allen 500 600 650
BTS Matthew 200 700 900
Finance Lisa 1000 900 700
Actuarial Vivian 150 450 650
Legal Wilson 250 100 150
Complian Darren 300 560 500
Complian Rosa 400 240 300
My report only show the monthly figures for a year, i.e. 12 columns.
Therefore when I sum up for each function, I also need to know which months
should be summed up for and calculate on my report.
I hope I explain myself clearly, if not please let me know...I think using
sumproduct is the solution but not sure why it is not working...please
someone help!!!!
Thansk a lot in advance
Vivi