IF formula error.

[SUDHAKAR-FRONTIER]

Dear All,

Kindly help me the below details..

=IF(OR(A:A="PCS PRODUCT",A:A="PCS SERVICE"),SUMIFS(C:C,B:B,"HP"))=3227054

=IF(OR(A:A="ECS SERVICE",A:A="ECS PRODUCT"),SUMIFS(C:C,B:B,"HP"))=3227054,

i choose the product ECS & PCS, but values should be different but when i am trying the formula, still i am getting same error.., here i attached the my file 

And also i have to use IF(logical test1, IF(logical test2, SUMIF(range, criteria1,criteria1 ))), please help me..

[#2]

@SUDHAKAR-FRONTIER 

OR(A:A="PCS PRODUCT",A:A="PCS SERVICE") returns a single TRUE/FALSE value, not an array. Since there is at least one cell in column A that contains PCS PRODUCT, it returns TRUE. The same goes for OR(A:A="ECS SERVICE",A:A="ECS PRODUCT"). So both formulas are equivalent to =SUMIFS(C:C,B:B,"HP").

Try

=SUM(SUMIFS(C:C,A:A,{"PCS PRODUCT","PCS SERVICE"},B:B,"HP"))

or

=SUMIFS(C:C,A:A,"PCS *",B:B,"HP")

[#3]

Thank you so much Hans,

Now its working fantastic...