Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   How to Sum multiple columns (http://www.baanboard.com/baanboard/showthread.php?t=69838)

sai krishna 10th March 2017 11:08

How to Sum multiple columns
 
Hai Friends,

i want to sum all from values in which are in coloumn wise,here i have to sum multiple coloumns in excel..I have taken like this
diatotal =diatotal + multql and i intially taken diacode =0 here i tried by taking multiple variable but i didnt get the exact result.coloums from (I to Y) i have add these bt coloumn wise.if any one know can you please help

Thanks & Regards
siva sai krishna.v

BChary 10th March 2017 12:11

If you want sum multiple columns in excel just use
Code:

=SUM(I:Y)
this function gonna sum any value from column I to column Y.
PS. in your excel this function may have diffrent name


All times are GMT +2. The time now is 17:48.


vB.Sponsors
©2001-2018 - Baanboard.com - Baanforums.com