Formula Help

Home – Le CFO masqué › Forums › Excel › Formula Help

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 26 November 2022 at 10 h 41 min #123059
    Nidhi Puri
    Participant

    Is it possible to drag the Sumif formula horizontally – the criteria is the same but the sum range changes and is available on a different excel tab at 4 columns interval.

    If I manually enter the formula in column 1 – =SUMIFS(‘1) Tab 1′!AD$6:AD$1317,’1) Tab 1’!$D$6:$D$1317,’Store count!$A3)
    If I manually enter the formula in column 2 – =SUMIFS(‘1) Tab 1′!AH$6:AH$1317,’1) Tab 1’!$D$6:$D$1317,’Store count!$A3)

    If not, is there another embedded function that would help with this.

    Thank you for your help.

    29 November 2022 at 11 h 54 min #123149
    Sylvie Giroux
    Participant

    I would like to help you, but I admit I have difficulty understanding your request. Can you leave an example file?

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.