php - Sum excel rows based on a cell value -
php - Sum excel rows based on a cell value -
i have spreadsheet has between 10-12 columns. want sum number of rows, in html. however, want sum dependent on specific column value.
column 9, we'll say, pull downwards 6 different possible choices. so, want sum "choice 1" , nowadays number in 'div' section.
note: using php's create website.
example:
possible values: "a,b,c,d,e,f,g"
$sum_a=sum(rows value) echo "these number of rows a" . $sum_a .
i haven't found much online helped me, maybe i'm wording search wrong.. help appreciated!
tia!
if have excel tool want export in html website?
if that's case, might interested in appizy (http://appizy.com). website converts excel spreadsheet dynamic webapplication. can download html, css, javascript code , paste website.
hope helps. nicolas
php html excel import export
Comments
Post a Comment