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

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies