Sumif with two conditions

[mikmcelroy]

Hi, I'm making a personal budget. I have a budget form that I need to sum data from a long list of expenses for the correct month. In other words, I need to add up all the money we spent on "Client Entertainment" for Jan, Feb, Mar, etc.

Here's an example below of a few of my budget line items, along with a list of random expenses. I need the budget line labeled "Home - Cleaning" to return "19" under the month of Aug in this example. Any help would be great!!

Health & Fitness - Gym

Health & Fitness - Haircuts

Health & Fitness - Misc

Home - Cleaning

Home - Furnishings

Home - Pest Control

Home - Repair

<colgroup><col></colgroup><tbody>
</tbody>

Sheet 2: 08/01/2014 SPOTIFY USA 405621688010 SE 9.99 Entertainment - Spotify 08/03/2014 NETFLIX WWW.NETFLIX.LOS GATOS CA 7.99 Entertainment - Netflix 08/03/2014 TARGET STORE T2613 2CHICAGO IL 45.6 Food and Dining - Groceries 08/03/2014 WHOLEFDS KBS 10252 03125870648 44.75 Food and Dining - Groceries 08/03/2014 WWW.HOMEJOY.COM 8555698783 CA 19 Home - Cleaning <colgroup><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[Andrew Poulsom]

Welcome to MrExcel.

What version of Excel do you have? In Excel 2007 and above you can use SUMIFS.

 

[mikmcelroy]

Excellent, thanks for the very quick response! I actually heard from a friend just before, and sure enough, SUMIFS did the trick. Thanks!