Sum values with PROCV

Question

Sum values with PROCV

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 each month. With the formula I'm using at the moment =SOMA(PROCV(A3;Alimentos!C3:K3000;7;0)), i'm just getting the value for the first month and not the sum of all the months.

To clarify the Formula:

A3 is the food I'm looking for;
Alimentos!C3:K3000 is the range of the table where I'm looking for the data;
finally 7 will be the index of the column where the amount spent per month is.

I think there is no extra information.

0

excel procv soma

Author: Rekcs, 2020-02-11

Source

1 answers

score 0 · Answer 1

Very simple to solve, use the sum :

=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! containing the value of cell A3.