Adding a single cell to a range in excel -

Adding a single cell to a range in excel -

i'm trying run formula in excel receives range of cells , performs action on them. thing is, pass range of cells, cell not in range.

do know way of doing so?

before suggest, i'll that, unfortunately, formula doesn't work sum, meaning, doesn't have endless fields come in separate values. has 1 field range of values (to want have range , separate cell), , after comma, another, different, value should come (meaning, can give range, comma, other value).

thanks guys

what can achieved vba.

for illustration switch visual basic editor (alt+f11), create new module (insert, module), come in next code , save.

public function sumpow(param1 range, param2 double) double each c in param1 sumpow = sumpow + c.value next c sumpow = sumpow ^ param2 end function

now go excel sheet , can utilize formula =sumpow(range, cell).

it output sum of values in range raised powerfulness of value in single cell.

excel excel-formula