# Excel-ish functions on power table

**URL:** <https://forum.inductiveautomation.com/t/excel-ish-functions-on-power-table/15646>\
**Category:** General Discussion\
**Created:** [October 11, 2017, 8:59pm UTC](https://forum.inductiveautomation.com/t/excel-ish-functions-on-power-table/15646 "2017-10-11T20:59:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jmoller](https://avatars.discourse-cdn.com/v4/letter/j/0ea827/32.png) [@Jmoller](https://forum.inductiveautomation.com/u/Jmoller)\
**Post date:** [October 11, 2017, 8:59pm UTC](https://forum.inductiveautomation.com/t/excel-ish-functions-on-power-table/15646/1 "2017-10-11T20:59:02Z")

</div>

Is there any way to fire an event on cell(s) selected? I’d like to put a footer at the bottom of some tables and do a sum, avg, and stdev on just the selected data. Looks like none of the mouse events work except the ones in the extension functions. An onMouseReleased function would be handy.

Thanks

---

<div class="post-metadata">

**Author:** ![Jmoller](https://avatars.discourse-cdn.com/v4/letter/j/0ea827/32.png) [@Jmoller](https://forum.inductiveautomation.com/u/Jmoller)\
**Post date:** [October 11, 2017, 9:21pm UTC](https://forum.inductiveautomation.com/t/excel-ish-functions-on-power-table/15646/2 "2017-10-11T21:21:32Z")

</div>

Nevermind. These three events fire after you drag and select cells.

selectedRows  
selectedColumn  
selectedColumns

evtList = [“selectedRows”]  
if event.propertyName in evtList:  
print “Do Stuffs”