Integration in Excel

[JGLWouters]

Is there any function or add-on available in Excel to do an integration calculation or to calculate the surface of an area under a graph?

 

[jkpieterse]

What shape is your data in? It could be as simple as adding a column next to it which takes the product of the y-value and the delta-x and sums it sequentially.

 

[JGLWouters]

Thanks for your answer, but I'm familiar with the approximation method. I'm looking for a way to calculate the integral based on the function of the graph, from a starting value to an end value. I've tried to download several add-ons, but I can't find a proper one to do the job.

 

[jkpieterse]

I guess if you are looking to determine the true mathematical integral function you'd be better off using a product like Mathematica I am not aware of any Excel tools that are capable of algebraic integration

 

[JGLWouters]

I agree. Maybe something to consider for future versions of Excel? For now, let it rest, unless someone has an add-on solution that works.
Thanks again for your reply.

 

[wideboydixon]

This is the best match I could find:

https://excel-works.com/

WBD

 

[JGLWouters]

Thanks for the suggestion, but I tried that one. I have Excel (Office) 2016, 64 bit and installed the trial version. Nothing showed. The 32 bit version didn't install either. I tried that one also.