Jul 28 2019 01:47 PM
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.
Jul 28 2019 03:17 PM - edited Jul 28 2019 03:23 PM
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