# SUMIF or SUMIF's formula with multiple criteria

1. ## SUMIF or SUMIF's formula with multiple criteria

Hi. I am currently working on a personal balance sheet. On one tab, I basically have my ledger of accounts listing the date of the transaction, the description, the amount debited, the amount credited, and the classification of purchase.

I would like to create a formula on a separate tab that would sum all of the "Gas" items for the each month.

Forum Question.JPG

From this data, I would get the following sums for "Gas:"
March 2013 = -85.00
September 2013 = -86.00

I was able to create two sumif formulas, but I cannot seem to combine them so that they meet both the data range and the classification criteria.

Thanks,

Jackie

2. ## Re: SUMIF or SUMIF's formula with multiple criteria

Hi and welcome to the forum

For future reference, please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

To sum based on multiple criteria, you need to use the sumifS() function. Maybe something like...
=sumifs(E:E,F:F,"Gas",A:A,">=3/1/2013",A:A,"<=3/31/2013")

There are currently 1 users browsing this thread. (0 members and 1 guests)