Formula to sum

[oeyandyprawira]

Hi,
Please refer to attached file

I need formula in sheet target column:

B2 = data in sheet source If column A = acc/Fin then sum column E&F
B3 = data in sheet source If column A = exco then sum column E&F + If column A = security then sum column E&F
B4 = data in sheet source If column A = front office then sum column E&F + If column A = reservation then sum column E&F + If column A = Premier then sum column E&F

Regards,
Andy

[MarvinP]

Hi Andy,

I think this is a perfect place to learn about Pivot Tables. See the attached where I've done a Pivot on your sheet 1 to get the answer.

[oeyandyprawira]

Hi Andy,

I think this is a perfect place to learn about Pivot Tables. See the attached where I've done a Pivot on your sheet 1 to get the answer.

Hi Marvin, thx for your replied but on B3 have 2 conditions, if column A = exco then sum column E&F + If column A = security then sum column E&F

, B4 have 3 conditions= data in sheet source If column A = front office then sum column E&F + If column A = reservation then sum column E&F + If column A = Premier then sum column E&F
11 oct 15.jpg

Regards,
Andy