Home » Forums » Open Source Learning Center » Question and Answer

Transmitted Total from Multiple Ranges

Submitted by A Kumarsreenivas on 2 May, 2014 - 09:05

Hi Team

In the attached spread sheet, We have a formula written for Transmitted Total.
This is formulated over the cells designated for Document Range. BEG and END.
Formula works good when the document range is single.
Formula dosn't hold good for multiple document ranges.

Please suggest us how to get this right for multiple document ranges too.

Thanks & Regards
KumarSreenivas A

AttachmentSize
Transmitted Total from Multiple Ranges.xlsx12.46 KB
‹ Help me please Excel Problem VBA ›
»
Nick's picture

change the format of your

Submitted by Nick on 7 May, 2014 - 22:21.

change the format of your data to not have multiple lines per range..

any other solution will be a nasty hack

»

Transmitted Total from Multiple Ranges

Submitted by A Kumarsreenivas on 12 May, 2014 - 13:10.

Thanks Nick.

Regards
KumarSreenivas A

»