Hello. I have attached a sheet with deleted out data. Starting in CP 174 there is a very hard formula that is supposed to sum data from the left (I had data there but I deleted it out) For some reason, the formula is returning a #ref formula. Can anyone explain what the formula is doing and why it is coming up #ref. It is not because there is missing data because the formula was coming up with ref even when there was data in the cells. Thanks. Very urgent.
yep your right its a ridiculously long formula whats it supposed to do?
"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
Hahahha. It's a sumif formula I suppose. That's what you are supposed to tell me lol.
That formula is ridiculous, but I'm not getting a #ref error I get a #DIV/0 error in Cell CP174 and all the other cells in that region. The divide by 0 error is correct since that's the result of the last part of the formula SUMIFS($D77:$CJ77,$D$5:$CJ$5,CP$5,$D$7:$CJ$7,CP$7) = 0
Tom S.↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the leftIf your question is resolved, mark it SOLVED using the thread tools.
Have you looked at cell A56? It missing a value and has a lot of dependent cells. Click on it and go to the formula auditing and click trace dependents several times until you see all the cells that work off that cell. Good luck!
Wow! ...
Einstein is alive and well, in a spreadsheet in Los Angeles, along with Walt & Elvis.
I think you seriously want to reconsider your sheet layout, it's as ridiculous as the offending formula!
Can we take a few steps back and look at your raw data and your objectives?
KISS
I didn't create the spreadsheet. I'm not that smart/dumb lol. Anyways, it appears the cell was referencing a lot of blank cell as Tank997 said. Thanks.
Alex
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks