Easy formula

Copper Contributor

Hello everyone,

In Column A, I have many categories such as "Matériel" or "Transport" (yes, it's french), in Column B, I have what I bought (corresponding to the categories in column A) and in Column C, I have the price of what I bought.

My question is : "What is the formula to get the sum of all I bought by category ?" I want the sum of all what I bought in "Matériel" and the sum of all what I bought in "Transport".

I think it's pretty easy but I can't find any solution.

Thank you in advance.

 

1 Reply

@acabero 

Hi

For Total Materiel in G3   >>   =Sumif(A1:A8,"Materiel",C1:C8)

For Total Transport in G4   >> =Sumif(A1:A8,"Transport",C1:C8)

Hope that Helps

Nabil Mourad