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





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

Please checkout these links to learn more about it:


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