SOLVED

Formular

%3CLINGO-SUB%20id%3D%22lingo-sub-843110%22%20slang%3D%22en-US%22%3EFormular%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843110%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%202016%20(Excel)%3C%2FP%3E%3CP%3EHave%203%20columns%20of%20data%3CBR%20%2F%3E1%20Description%3CBR%20%2F%3E2%20Credit%3CBR%20%2F%3E3%20Debit%3CBR%20%2F%3EI%20want%20a%20total%20(SUM)%20of%20all%20%24%20values%20in%20Debit%20which%20correspond%20to%20a%20particular%20line%20of%20Description%20column%3C%2FP%3E%3CP%3EWhich%20formulae%20will%20give%20me%20best%20results%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-843110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843116%22%20slang%3D%22en-US%22%3ERe%3A%20Formular%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F405594%22%20target%3D%22_blank%22%3E%40NovaStar%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20SUMIF%20function%20is%20what%20you're%20looking%20for.%3C%2FP%3E%3CP%3EPlease%20checkout%20these%20links%20to%20learn%20more%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsumif-function-169b8c99-c05c-4483-a712-1697a653039b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsumif-function-169b8c99-c05c-4483-a712-1697a653039b%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-sumif-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-sumif-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843151%22%20slang%3D%22en-US%22%3ERe%3A%20Formular%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843151%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%2C%20that%20did%20it%20...%20saved%20me%20a%20ton%20of%20time%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
NovaStar
New Contributor

Office 2016 (Excel)

Have 3 columns of data
1 Description
2 Credit
3 Debit
I want a total (SUM) of all $ values in Debit which correspond to a particular line of text in the Description column

Which formulae will give me best results?

2 Replies
Solution

@NovaStar

 

Hi,

 

I think SUMIF function is what you're looking for.

Please checkout these links to learn more about it:

https://support.office.com/en-us/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b

https://exceljet.net/excel-functions/excel-sumif-function

 

Hope that helps

@Haytham Amairah 

Thank you so much, that did it ... saved me a ton of time