IF formula correction

[Excel_Assis]

Could some one please help me with this IF formula. Excel reports I am missing a parenthesis but I do not know where.


=IF(N(SUM($B$6:$B$14&$D$6:$D$14&$F$6:$F$14=B17&D17&F17),SUM($B$6:$B$14&$D$6:$D$14&$F$6:$F$14=B17&D17&F17)

 

[ayazgreat]

Just Simply by removing blank columns and row in sheet1

 

[Excel_Assis]

Ayazgreat Could you send me the Pivot Table you did or explain how you did it and formatted it to look like that.

 

[ayazgreat]

I can send you an example workbook by mail and when you get it, it is easy to be explained.

 

[VoG]

This seems to be the same question http://www.mrexcel.com/forum/showthread.php?t=551764

 

[ayazgreat]

Thanks Vog