LinkBack URL
About LinkBacks
Hi all, could you helpo me with this?
=SUMPRODUCT((L5:L9)*(L5:L9>0)) but it's suming the numbers instead of multiplying them!
Hi all, could you helpo me with this?
=SUMPRODUCT((L5:L9)*(L5:L9>0)) but it's suming the numbers instead of multiplying them!
Can you post some sample data...and the results you want to calculate?
I think that your formula shoulb be:
=SUMPRODUCT(L5:L9,L5:L9)
to give the sum of each number multiplied by itself.
EllBol.
Perhaps =PRODUCT(IF(L5:L9>0, L5:L9))
Confirmed with Ctrl+Shift+Enter, rather than just Enter.
Entia non sunt multiplicanda sine necessitate
=PRODUCT(IF(A1:A9=0,1,A1:A9))
array entered should give the desired result(it allows for -ve values)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for replying, see attached an example
then either shg's or mine will work
=PRODUCT(IF(F3:F7=0,1,F3:F7))
or
=PRODUCT(IF(F3:F7>0, F3:F7))
Dont forget to array enter with ctrl+shift+enter
see how to enter array formula link in my signature
Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks