Total in column results in value error

[bdf1965]

Please see attached work book , second part contains same type of formula as top part but bottom total is resulting in a value error

[moinsk21]

Hi,

Kindly use below formula...

Please Login or Register  to view this content.

Thanks!
Moinuddin Shaikh

If you like my Response:
1. Show appreciation to those who have helped you by clicking "* Add Reputation" below their posts.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Appreciate someone towards their career path is better than saying Thanks!
-Moin

[bdf1965]

Thank you , it has added them up but there are to many digits total should be 16394 not the 1639436 as showing
regards
brian

[moinsk21]

You Welcome.


Thanks!
Moinuddin Shaikh

If you like my Response:
1. Show appreciation to those who have helped you by clicking "* Add Reputation" below their posts.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Appreciate someone towards their career path is better than saying Thanks!
-Moin