Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th March 2017, 12:08
sai krishna sai krishna is offline
Junior Member
 
Join Date: Dec 2016
Posts: 12
sai krishna is on a distinguished road
Baan: 10.04 - DB: baan sql - OS: windows 10
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
Reply With Quote
  #2  
Old 10th March 2017, 13:11
BChary's Avatar
BChary BChary is offline
Junior Member
 
Join Date: Apr 2016
Location: Poland
Posts: 9
BChary is on a distinguished road
Baan: Infor LN 10.4/10.5 - DB: SQL Server - OS: W10
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

Last edited by BChary : 10th March 2017 at 13:39.
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum on a multi occurrence form per line alexpreyer Tools Development 4 20th September 2010 12:13
Multiple divisions of our customer/customer for our multiple divisions VilasoorRavi Finance, Invoicing and Integration 1 14th August 2006 09:48


All times are GMT +2. The time now is 03:26.


©2001-2017 - Baanboard.com - Baanforums.com