Using SUMIFS for criteria in two different tables
I am trying to us 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)
Would be better if you upload a sample workbook with desensitized data.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
Teach me Excel VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks