Forum Discussion
mrman
Sep 09, 2025Occasional Reader
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('Tra...
m_tarler
Sep 09, 2025Bronze Contributor
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)