Posts by JAugusto • 1 point

• 0

  votes

  1

  answer

  15

  views

  A: SUMIFS + INDEX MATCH with repeated matches

  Use the following formula, where K2 is the Tec, L2 is the start date and M2 is the End date. =SUMPRODUCT(D3:I7*(A3:A7=K2)*(D2:I2>=L2)*(D2:I2<=M2)).

  excel

  answered 3 years, 5 months ago JAugusto 1

• 0

  votes

  3

  answers

  42

  views

  A: Average function in excel

  You can use the following formula to avoid using the offset (volatile) function, which is executed whenever there is any change in the Excel sheet.…

  excel formatting

  answered 3 years, 5 months ago JAugusto 1