Formula that Sums total for only rows that contain a certail value?

Please see the attachted picture.

I trying to calculate the total amounts for all purchases that are gas, misc., groceries/dining, debit vs credit.

How do i go about doing this?

the picture hasnt been displayed but take a look at SUMIF function to see if that helps you, ideally if you require more help then uploading your workbook will make it easier to understand.

Hi Baumerr,

Welcome to the forum!!!

You can simply use SUMIFS function to get your expected result. Refer the following formula - "=SUMIFS(sum_range (column for which you wanted to get the total), criteria_range1 (select your range of criteria in your case it will be list of purchases),criteria1 (make unique list of purchases for which you wanted to get the total and select it).

Assuming you have your sum range from column C2, your criteria range from column B2 and you have unique list of purchases from column D2 so your function will look like somewhat..

=SUMIFS(C:C,B:B,$B2)

Let me know if it works for your or please upload your sample file to get your answer more quickly.

I attached the excel file above.

I don't really understand the SUMIF formula.

Please refer the attachment to see your expected result.

Originally Posted by baumerr1

I attached the excel file above.

I don't really understand the SUMIF formula.

SUMIF basically gives you sum for different criteria you have taken in formula.

Hi baumerr,

Please take few seconds to mark this thread as SOLVED and say Thanks to the person by adding *Add Reputation who helped you.

Cheers!!!