Sum values with PROV

Asked

Viewed 1,236 times

0

I have an Excel sheet with monthly spending per food. The goal is, on a separate sheet, to calculate the sum of each food in every month. With the formula I’m using right now =SOMA(PROCV(A3;Alimentos!C3:K3000;7;0)), is just going to get me the value for the first month and not the sum of all the months.

To clarify the formula:

  1. A3 is the food I’m looking for;
  2. Alimentos!C3:K3000 is the range of the table where I am looking for the data;
  3. Finally the 7 will be the index of the column where is the amount spent per month.

I don’t think there’s any extra information.

excel summing-up procv

  • If I have understood correctly, what you need to use is the SOMASE function, here is a tutorial https://ninjadoexcel.com.br/aula-howto use a-funcao-somase-excel/

1 answer

0

Very simple to solve, use the SOMASIS:

=SOMASE(Alimentos!J:J;A3)

With this formula you will sum all the values of column J (in case the value 7 of procv) in the Food! tab that contain the value of cell A3.

Browser other questions tagged excel summing-up procv

You are not signed in. Login or sign up in order to post.