If statements within Array formulas

[MTBer]

I'm putting together a crosstab report using an array formula, th
formula is as follows

{=SUM(IF($A3&D$2&CC_Choice=HYP&date&CC,Amount))}

This basically produces a cost centre report for the Cost Centre Choic
by account code by month.

I now wish to add an extra field of selection, by Business Unit, if
BU is selected a cost centre would not be selected so the CC-Choic
field will be blank, and vice versa.

Is it possible to put an If statement into the above formula t
determine if the report is by CC or BU.

My best attempt involves having a IF statement that checks if the fiel
is populated and then runs the cc formula or bu formula,on the tru
false conditions.

thanks for your assistance

 

[Guest]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[Frank Kabel]

Hi
you may consider using a pivot table for this. Otherwise I
would suggest also using a IFformula