Formular

[NovaStar]

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 · Accepted 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

[#3]

@Haytham Amairah 

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