Not accurate result of SUM

[shantraj.antin@gmail.com]

Dear Friends,


From the attached file


1> I am not getting the accurate result for the SUM of Column value BL+BQ= in Column BR


2> AND SUM of Columns BM+BN+BS+BT = in Colulmn BW (If any cell value is NA it should ignore and sum the other values)


Attachment Link


https://skydrive.live.com/#cid=7DE9A52F4913C67B&id=7DE9A52F4913C67B%21102


Thank you for your Support.

 

[Hui]

Shan


1. The formula in BQ2 is =IF(AND(BL2="NA", BQ2="NA"),"NA",SUM(BL2:BQ2))

which sums the range from BL2 to BQ2 and includes the hidden column BO

The answer 1.47 is correct as the sum of BL2, BM2, BO2, BP2 & BQ2


2. =SUM(BM2,BN2,BS2,BT2)

 

[shantraj.antin@gmail.com]

Thank you Hui