Evening,
I'm just trying to use a simple formula which for some reason is showing as #Value error:
=sum(F13-G13:K13)
in column L
I'm then going to use conditional formatting to show if the values are positive or negative.
P.S. this document it completely desensitised and is purely an example!
Example attached
Cheers
Perhaps this is what you intend to do?
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
That did the trick! Cheers Sourabh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks