using tables udf's comparison 2007

i am minute udf comparison 2007 i wish pass list to, following anxiety tools list udf. so, instance list called "stock" competence feeling something this:

name            cost            equipment stock

teddy bear    £10              10

lollipops         20p              1000

i have udf i wish calculate sum cost equipment left batch (the tangible instance many some-more challenging can't unequivocally finished but unequivocally challenging formula)

ideally syntax udf feeling something like

totalprice(stock)

which i work out meant udf have signature

function totalprice(table range) variant

what i am carrying problem anxiety columns list iterate by them. ideally i'd means referencing buttress headers (so something table[cost]).