Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Formula extension help

  • Prabhavathi Robert
  • Topic Author
  • Offline
  • New Member
  • Nove države
More
4 months 1 week ago #1402 by Prabhavathi Robert
Formula extension help was created by Prabhavathi Robert
Hi,

I need help in one of excel formula where the formula needs to be changed horizontally when dragged, but this works only vertically, I need this in order to calculate Total Breaks from reference cell for each day.


='6th Feb'!K3 ( COLUMN "B") now when I drag this vertically it changes as ='6th Feb'!K4, ='6th Feb'!K5,='6th Feb'!K6 .which is good now I need this to be the same way for Horizontally along with date change and cell reference to be changed, but its not happening. Please help.

Big Thank you in advance.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoQiu hongkunJay Chivo