Home

Easy formula

%3CLINGO-SUB%20id%3D%22lingo-sub-776700%22%20slang%3D%22en-US%22%3EEasy%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776700%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EIn%20Column%20A%2C%20I%20have%20many%20categories%20such%20as%20%22Mat%C3%A9riel%22%20or%20%22Transport%22%20(yes%2C%20it's%20french)%2C%20in%20Column%20B%2C%20I%20have%20what%20I%20bought%20(corresponding%20to%20the%20categories%20in%20column%20A)%20and%20in%20Column%20C%2C%20I%20have%20the%20price%20of%20what%20I%20bought.%3C%2FP%3E%3CP%3EMy%20question%20is%20%3A%20%22What%20is%20the%20formula%20to%20get%20the%20sum%20of%20all%20I%20bought%20by%20category%20%3F%22%20I%20want%20the%20sum%20of%20all%20what%20I%20bought%20in%20%22Mat%C3%A9riel%22%20and%20the%20sum%20of%20all%20what%20I%20bought%20in%20%22Transport%22.%3C%2FP%3E%3CP%3EI%20think%20it's%20pretty%20easy%20but%20I%20can't%20find%20any%20solution.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776736%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776736%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383418%22%20target%3D%22_blank%22%3E%40acabero%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EFor%20Total%20Materiel%20in%20G3%26nbsp%3B%20%26nbsp%3B%26gt%3B%26gt%3B%26nbsp%3B%20%26nbsp%3B%3DSumif(A1%3AA8%2C%22Materiel%22%2CC1%3AC8)%3C%2FP%3E%3CP%3EFor%20Total%20Transport%20in%20G4%26nbsp%3B%20%26nbsp%3B%26gt%3B%26gt%3B%20%3DSumif(A1%3AA8%2C%22Transport%22%2CC1%3AC8)%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
acabero
Occasional Visitor

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

Related Conversations