Posts by Jonathan Marckert • 11 points

• 1

  votes

  2

  answers

  3906

  views

  A: How to add values related to a line, searched with the Index + Corresp function in Excel?

  Use the formula Soma(Intervalo), along with the Somase(Intervalo,critério,intervalo_soma) Use like this: =Soma(Somase(B70:B72,B71,C70:C72),Somase(B70:B72,B71,D70:D72),Somase(B70:B72,B71,E70:E72))…

  excel

  answered 5 years, 3 months ago Jonathan Marckert 11