# Adding together multiple Sum Filter or Sumifs with multiple conditions across multiple sheets?

So I have a budgeting spread sheet. I have an overview page that I need to link to a "Checkings" sheet and a "CC-Chase" sheet.

To calculate the amount spent on a specific category that month I currently use: `=sum(filter(Checkings!\$B:\$B,Checkings!\$C:\$C=("Grocery"),Checkings!\$A:\$A>=("1/1/21")+0,Checkings!\$A:\$A<=("1/31/21")+0))`

I want to add in the same data from my credit card statments so I tried: `=sum(filter(Checkings!\$B:\$B,Checkings!\$C:\$C=("Grocery"),Checkings!\$A:\$A>=("1/1/21")+0,Checkings!\$A:\$A<=("1/31/21")+0))+(FILTER('CC-Chase'!\$F:\$F,'CC-Chase'!\$D:\$D=("Grocery", 'CC-Chase'!\$B:\$B>=("1/1/21")+0,'CC-Chase'!\$B:\$B<=("1/31/21")+0)))`

I have also tried: `=sum(filter(Checkings!\$B:\$B,Checkings!\$C:\$C=("Grocery"),Checkings!\$A:\$A>=("1/1/21")+0,Checkings!\$A:\$A<=("1/31/21")+0))+sum(FILTER('CC-Chase'!\$F:\$F,'CC-Chase'!\$D:\$D=("Grocery", 'CC-Chase'!\$B:\$B>=("1/1/21")+0,'CC-Chase'!\$B:\$B<=("1/31/21")+0)))`

But these gives me an error. I've tried a few other combinations of this but always get an error.

Does anyone know what I'm doing wrong or have another way I could do this?

• Welcome. What result were you expecting? The most obvious difference between the two formula is that you `sum` the filter for "Checkings" but you don't `sum` the filter for "CC-Chase". Feb 27 at 4:25
• I want to pull the sum of anything with the category "Grocery" from both "Checking" and "CC-Chase" if the date is in January. I've tried this as well: '=sum(filter(Checkings!\$B:\$B,Checkings!\$C:\$C=("Grocery"),Checkings!\$A:\$A>=("1/1/21")+0,Checkings!\$A:\$A<=("1/31/21")+0))+sum(FILTER('CC-Chase'!\$F:\$F,'CC-Chase'!\$D:\$D=("Grocery", 'CC-Chase'!\$B:\$B>=("1/1/21")+0,'CC-Chase'!\$B:\$B<=("1/31/21")+0)))' but even with the additional sum I still get an error. I'll upload some screenshots. Feb 27 at 19:18
• Understand that writing or helping to solve formulas when we don't have access to your sheet or data is challenging. It either all has to be done in our heads without testing, or we'd have to manually enter all of your data ourselves to test (which is unrealistic). The most efficient and effective way to receive help is to share a link to your spreadsheet (or a copy of it). That said, scanning it, try simply removing the final closing parenthesis from your third formula shown in your post. Feb 27 at 19:55
• Ah that makes a lot of sense! Sorry first time posting something on here. I'll share a copy of the sheet and add it to the main post too. Also I did try to remove the parenthesis but still same error shows up. docs.google.com/spreadsheets/d/… Feb 27 at 20:07
• You've set the spreadsheet so that "access" must be applied for. If you want the maximum number of volunteers to look at your issue, please allow access to anyone with the url. Mar 1 at 9:34

There is just a spelling mistake in your formula

This part: `+sum(FILTER('CC-Chase'!\$F:\$F,'CC-Chase'!\$D:\$D=("Grocery",`
should be: `+sum(FILTER('CC-Chase'!\$F:\$F,'CC-Chase'!\$D:\$D=("Grocery"),`

Actually you do NOT need the parenthesis around the text values.
You can replace `("Grocery")` with `"Grocery"`

EDIT (after having a look at your sheet)

Pro Tip

You can further simplify your formula using the SUMIFS function instead of the ones you now use,
turning this formula

``````=SUM(FILTER('CC-Chase'!\$F:\$F,'CC-Chase'!\$D:\$D=("Grocery"),'CC-Chase'!\$B:\$B>=("1/1/21")+0,'CC-Chase'!\$B:\$B<=("1/31/21")+0))
``````

to this formula

``````=SUMIFS('CC-Chase'!F:F,'CC-Chase'!\$D:\$D,"=Grocery",'CC-Chase'!\$B:\$B,">=1/1/21",'CC-Chase'!\$B:\$B,"<=1/31/21")
``````
• Please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. Mar 1 at 16:57
• Oh my gosh! Thank you so much! I've been trying for so long to get this to work and never saw that. Also thank you for the SUMIF solution as well! I had tried to do it with the SUMIFS previously but wasn't able to get it to work but with your solution I now see why for that as well. Mar 1 at 18:11
• Glad I could help. Mar 1 at 18:47