Using SUMIFS for criteria in two different tables

[queenbean84]

I am trying to use SUMIFS to total criteria in two different tables. These are the two formulas I am using in two different cells. I want to combine the two into only one cell. I am using Excel 2016.

=SUMIFS(list_purchases[Grand Total],list_purchases[Date],">"&beg_date-1,list_purchases[Date],"<"&end_date+1)

=SUMIFS(list_scrap[Total],list_scrap[Date],">"&beg_date-1,list_scrap[Date],"<"&end_date+1)

 

[snjpverma]

I am trying to use SUMIFS to total criteria in two different tables. These are the two formulas I am using in two different cells. I want to combine the two into only one cell. I am using Excel 2016.

=SUMIFS(list_purchases[Grand Total],list_purchases[Date],">"&beg_date-1,list_purchases[Date],"<"&end_date+1)

=SUMIFS(list_scrap[Total],list_scrap[Date],">"&beg_date-1,list_scrap[Date],"<"&end_date+1)

Why not add a + operator and add both the formulas ?
Like this :

=(SUMIFS(list_purchases[Grand Total],list_purchases[Date],">"&beg_date-1,list_purchases[Date],"<"&end_date+1))+(SUMIFS(list_scrap[Total],list_scrap[Date],">"&beg_date-1,list_scrap[Date],"<"&end_date+1))

 

[queenbean84]

Thank you so much! I was trying to do that but I forgot the double quotes!

 

[snjpverma]

Glad to see it worked for you