Hi
I've attached an excel spreadsheet, see DCF Tab - Row 49 (highlighted in yellow).
Excel can't seem to add up the numbers correctly.
I've tried clearing contents but it doesn't really help.
Appreciate your advice!
Thanks!
Hi
I've attached an excel spreadsheet, see DCF Tab - Row 49 (highlighted in yellow).
Excel can't seem to add up the numbers correctly.
I've tried clearing contents but it doesn't really help.
Appreciate your advice!
Thanks!
First thing I got when I opened your workbook was a circular reference error for B12, so I changed B12 to this
=SUM(B10:B11)
and the other formulas now work OK.......
Audere est facere
b12 has =SUM(B10:B12) which is a circular reference change it to =SUM(B10:B11)
"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
Thank you daddylonglegs and martindwilson for your prompt replies!
Really appreciated it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks