Forum Discussion
SUMIFS function won't give me a sum for 1 text criteria and date range
I have been trying to create a formula that will pull the sum of my various expenses/income according to the their category and within a month's range. Here is the formula I wrote:
| =SUMIFS('Transactions'!E:E,'Transactions'!C:C,'Gifts','Transactions'!A:A,'>='&'1'!G2,'Transactions'!A:A,'<='&'1'!H2) |
I want the sum to populate on the sheet named '1' and I'm having it pull the info from the sheet named 'Transactions,' which has a masterlist of all my transactions for the year (both income and expense) which includes the columns date, paymentmethod, type, description, and amount. I have data validated date, paymentmethod, type, and amount. Column E is amount, C is type (which includes 'Gifts'), and A is date. G2 and H2 are start date and end date which I typed out as 1/1/25 and 1/31/25. They are formatted as dates and data validated.
Every time I press enter on this it just shows what I typed with red dotted lines around it. Other basic functions work (e.g. sum) but this one won't. Any idea how I can get this to work?
1 Reply
I think you need double quotes " around the strings:
=SUMIFS('Transactions'!E:E,'Transactions'!C:C,"Gifts",'Transactions'!A:A,">="&'1'!G2,'Transactions'!A:A,"<="&'1'!H2)
